on 04-09-2014 12:31 PM
Hi experts,
I am trying to insert the content to HANA tables from a java application.
my table name is : movies
my schemaID is :IDXXXXXX
i have set the connection string like "jdbc:sap://<server IP>:3XX15/?user=<userid>&password=<password>¤tschema=IDXXXXX". My prepared statement is like follows :INSERT INTO MOVIE VALUES (?,?,?,?,?,?,?,?,?,?). when i am executing my java application i am getting an error as
"invalid table name: Could not find table/view MOVIE in schema IDXXXXXX". can anyone help me?
Regards
Dinesh.
Hi All,
Thanks for all of your response. I solved the issue, problem is with the insert statement. we need to use the backslash to give the escape sequence. Following is the template to give insert statement.
INSERT INTO \"<SchemaName>\".\"<pkgname>::MOVIE\" (ID,TITLE,TITLE_ZH,YEAR,MPAA_RATING,RUNTIME,CRITICS_CONSENSUS,RELEASE_DATE,SYNOPSIS,POSTER) VALUES (?,?,?,?,?,?,?,?,?,?)"
Regards
Dinesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please give the full path schemaname.ownername.tablename and try again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error message is mentioning that the table is not present in that schema. Schema name and Table name are case sensitive.. if incase you are using a camel case or lowercase
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.