JDBC2ODBC & SqlServer

Hi All,

I have used sun jdbc2odbc for connecting to SqlServr database,But I have some problem with it.

When i use resultset for reteiving data from one table,that table will be locked and i cant use another resultset for retreiving data from that table simultancely,in other word I cant use several resultset in one time(It works for three resultset for one table).I dont know if it is the problem of sqlServer or problem of jdbc2odbc or I make some mistake in programming.

Do you have same problems before?and do you know how can i solve my problem?

[589 byte] By [Kamandi] at [2007-9-26 3:22:28]

«« distributing JavaHelp with an app
»» Float parsing

# 1

Hi Kamandi,

I'm not sure if this is what you are asking, but if I understand you correctly, you are trying to create three different resultsets from the same statement. According to the JDBC spec, you can't do this -- if you want three resultsets, you need three statements.

HTH,

Raj.

rajbhaskar at 2007-6-29 11:40:14 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

JDBC2ODBC & SqlServer

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified