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.
---- Thread 10b053 main Timestamp: 2003-04-03 16:37:50.718
==================================
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4 Build
000-000-000-000 on Java 1.4.0_01
new Connection 'jdbc:sapdb:///sapdb'
using [EMAIL PROTECTED] on Socket[addr=localhost/127.0.0.1,port=7210,localport=3253]
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (false)
[EMAIL PROTECTED] (INSERT INTO
DETAIL_TRAFIC(NETWORK_ELEMENT,SOURCE_FILE,RECORD_IN_FILE,ORIG_NADR,DEST_NADR,START_TIME,DURATION,SERVICE_ID,PRICE)
VALUES('?','?',?,'?','?',?,?,?,?))
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (1, NE0)
<-!
Timestamp: 2003-04-03 16:37:51.109
com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB: Cannot convert data NE0 to
type INTEGER.
at
com.sap.dbtech.jdbc.translators.DBTechTranslator.newParseException(DBTechTranslator.java:1155)
at
com.sap.dbtech.jdbc.translators.NumericTranslator.transStringForInput(NumericTranslator.java:451)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.setString(CallableStatementSapDB.java:1913)
at
com.sap.dbtech.jdbc.trace.PreparedStatement.setString(PreparedStatement.java:333)
at Import.main(Import.java:37)
