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

[Shafaqut Hussain]

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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[payal...@gmail.com]