maybe bug in jdbc driver

Thomas Markus <[email protected]> Wed, 17 Sep 2003 13:20:36 +0200

Newsgroups	gmane.comp.db.sapdb.general
Organization	Proventis GmbH
Message-ID	<[email protected]>

Hi,

I got an exception if I connect with sqlmode=ORACLE

com.sap.dbtech.jdbc.exceptions.InternalJDBCError: [getColumns][-8006] 
(at 204): Data types must be compatible
         at 
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB.internalQuery(DatabaseMetaDataSapDB.java:1027)
         at 
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB.getColumns(DatabaseMetaDataSapDB.java:299)


in command

dbconnection.getMetaData().getColumns(null, null, tablename, null)


this happens if I use jdbc driver
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4    Build 
001-000-156-985

if I use driver
package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 
Build 023-000-085-131"

or if i use sqlmode=INTERNAL all works fine

my db-kernel is  7.3.0 040-000-091-740


-- 
Thomas Markus
Tel: 030 29 36 399 - 18
mailto:[email protected]
Proventis GmbH
Torellstr. 1
10243 Berlin