Code working with Type 1 Driver and Not with Type 4 Driver 
Author Message
 Code working with Type 1 Driver and Not with Type 4 Driver

Hi,

I was using SQL with type 1 driver & following code was working fine.

..
  Statement stmt = conn.createStatement() ;
  stmt.addBatch("create table NodeTable ( ScenarioID varchar(255),
NodeID varchar(255) , ParentID varchar(255))") ;
  stmt.addBatch("create index NodeTableNodeID on
NodeTable(NodeID,ScenarioID)");
  stmt.addBatch("create table ScenarioInfo ( PatternId int, VersionNo
bigint , NodeID varchar(255))");
  stmt.executeBatch() ;
...

When I switched to type 4 driver, exception

com.microsoft.jdbc.base.BaseBatchUpdateException: [Microsoft][SQLServer
2000 Dri
ver for JDBC]????????????????????????????????????
       at
com.microsoft.jdbc.base.BaseStatement.executeBatchEmulation(BaseState
ment.java:709)
       at
com.microsoft.jdbc.base.BaseStatement.executeBatch(BaseStatement.java
:659)

is thrown

suggestions pls...

Thanks.

Regards,

Shafaqut Hussain

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Wed, 07 Dec 2005 00:05:56 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Difference between type 3 and type 4 drivers

2. Informix JDBC driver? (type 4 or type 2)

3. Informix JDBC driver? (type 4 or type 2)

4. Looking for Source Code for JDBC 2.0 Driver (any type)

5. The specified SQL type is not supported by this driver

6. Class Driver not found in type declaration.

7. Oracle Thin Driver works - Oracle OCI Driver does not

8. Advanced Queuing: ORA-25215 user_data type and queue type do not match

9. Type, sub-type, and sub-sub-type database design

10. Type 4 JDBC driver--Cost

11. where can I get a type 4 driver

12. ][ODBC SQL Server Driver]Fetch type out of range


 
Powered by phpBB® Forum Software