Hi Pranas,
your statement was:
INSERT INTO DETAIL_TRAFIC
NETWORK_ELEMENT,SOURCE_FILE,RECORD_IN_FILE,ORIG_NADR,DEST_NADR,START_TIME,DURATION,SERVICE_ID,PRICE)
VALUES('?','?',?,'?','?',?,?,?,?)
This means: Insert a lot of '?' string literals, and the first parameter is
RECORD_IN_FILE.
Do use '?' if you want a literal ?, do use ? if you want to use a parameter.
Cheers
Alexander Schr�der
SAP Labs Berlin
> -----Original Message-----
> From: Pranas Baliuka [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 03, 2003 4:45 PM
> To: [EMAIL PROTECTED]
> Subject: [JDBC] Metadata BUG
>
>
> Driver version: SAP DB JDBC Driver, SAP AG, 7.4.4
>
> Conditions:
> Table definition:
> CREATE TABLE "TEST"."DETAIL_TRAFIC"
> ("NETWORK_ELEMENT" Varchar (10) ASCII, ...
> Java:
> PreparedStatement stmt = connection.prepareStatement("INSERT INTO
> DETAIL_TRAFIC(NETWORK_ELEMENT,
> ...
> stmt.setString(1,"NE0");
> ...
> ------------------------------------------------------------
>
> Result:
> com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB:
> Cannot convert
> data NE0 to type INTEGER.
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
