com.ibm.db2.jcc.b.SQLException: under construction

com.ibm.db2.jcc.b.SQLException: under construction

Post by xix » Wed, 11 Dec 2002 06:44:59



i am using db2 udb v8.1 trial edition with type 4 jdbc driver, i have
this method issues.

resultset.updateObject(fieldname, object);

on rum time give me this sql exception,

SQL Exception: com.ibm.db2.jcc.b.SQLException: under construction

does this mean there is no support for this method? since i check the
documentation of the features of db2 jdbc driver, there is no
restriction on
resultset.updatexxx() on type 4 driver

 
 
 

com.ibm.db2.jcc.b.SQLException: under construction

Post by pm3iinc-nospa » Wed, 11 Dec 2002 07:36:03


JDBC 2.1 Core API Restrictions by the DB2 JDBC Type 4 Driver
The DB2 type 4 JDBC driver supports the JDBC 2.1 core API, however, it does
not support all of the features defined in the specification. The DB2 JDBC
driver does not support the following features:

  a.. Updatable ResultSets
  b.. New SQL types (Array, Ref, Java Object, Struct)
  c.. Customized SQL type mapping
PM

 
 
 

com.ibm.db2.jcc.b.SQLException: under construction

Post by xix » Thu, 12 Dec 2002 04:35:00


i would like to reiterate that i am using db2 v8.1 type 4 which is
called jdbc universal driver,based on the doc on the website, the
features unique to the driver include updateable resutset support.
actually i could create statement

                        statement = conn.createStatement(
                                ResultSet.TYPE_SCROLL_SENSITIVE,
                                ResultSet.CONCUR_UPDATABLE);

and use resultset.deletRow, but i am trying to use
resultset.updateObject gives me error, so if i couldn't use this, is
there a workround? thanks

 
 
 

com.ibm.db2.jcc.b.SQLException: under construction

Post by pm3iinc-nospa » Thu, 12 Dec 2002 15:53:02


i never tried the driver.
i think i read some where that you don't get any warning when asking for
an unsupported attribute (replaced by something else under the hood).
Maybe you can verify that the attribute is actually used.

I can't add more. (too limited knowledge on the topic)
i run the last beta so the doc/code may have changed.

PM

 
 
 

1. com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC:

hi, we are using db2 v8.1 fixpack 2 on NT. i have create a database
with code set UTF-8, when i try to copy the table from AS400 to DB2, i
got the error
com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -302,
SQLSTATE: 22001, SQLERRMC:

the table on AS400 contains Japanese data, i try to create the table
to store Japanese data on DB2.

But if i change the length of each field to 4 times of the original
length, i can pass and generate the table with data.

Since now on DB2 the length stored in sysibm.syscolomuns is 4 times of
the actual length, so i have to divide this length by 4 to get the
actual length of each field. But the problem is some of the fields is
substring of another field, e.g. apkey on AS400 is 8 length now, after
copy the table to DB2, it becomes 32 bytes long. i have key2
substr(apkey,1,6), then key2's actual length stored in
sysibm.syscolomuns, so looks like some of the fields are 4 times of
original field, some are the actual length. that causes my program
problem , because i assumes all the fiels definition must divide by 4
to get the right length .

i don't understand why i need to 4 times length, because as i see all
the value occupy one byte for up to 8 if the length is 8 bytes, if i
times 4 , that would be 32 length, so the rest 24 byte are space.
please help. thanks

2. Error running T-SQL debugger

3. com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031

4. insert row howto?

5. NoClassDefFoundError: com/ibm/db2/jcc/SQLJPackage

6. Structure of a table

7. Differences between COM.ibm.db2.jdbc.app.DB2Driver and COM.ibm.db2.jdbc.net.DB2Driver

8. VB, Images and Oracle

9. COM.ibm.db2.jdbc.appDB2Exception

10. COM.ibm.db2.jdbc.app/net.DB2Driver and AIX UDB connectivity from win95 PC

11. db2java.zip crash on OS/2 (COM.ibm.db2.jdbc.app.DB2Driver)

12. COM.ibm.db2.jdbc.DB2XADataSource

13. VB6/ADO com DB2(IBM RISC)