on 02-08-2006 8:16 PM
Hi
Can any one let me know your ideas , where i'm failing to insert data into JDBC..following error i'm getting insert into one column, but i'm able to insert the same column via sql query analyzer(MS-SQL)..and i tried with constant value for mapping , then its working fine..its able to inserted.
Unable to execute statement for table or stored procedure. 'SAP_PaymentReceiptFromSAP' (Structure 'StatementName') due to
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The name
'LN4717410' is not permitted in this context. Only constants, expressions,
or variables allowed here. Column names are not permitted.
>
Thank you,
reards..rambarki
Hi Rambarki,
I think the error is because your database table is expecting some kind of input and the input you are passing has some error in it.Just cross check the table using <b>DESCRIBE <tablename></b> with the data you are trying to enter.
It would be helpful, if you could give us your destination Data Type ( along with the content you are trying to indert )and your table structure.
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry..
my scenrio is rfc to jdbc..
regards..rambarki
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.