hibernate with sqlserver2000 and weblogic 8.1

vaibhavmca2004 · **Posted:** Thu Sep 16, 2004 6:51 am

we r presently developing an product called VCAB and using hibernate
in it .the product is ready and we tested it with mysql and it worked
fine but is not working with sqlserver.the exception it is giving in
weblogic 8.1 is an sql exception saying unsupported data conversion
lso there is an error after that saying unable to fetch input xml from
the database.can u plz guidwe me about what to do ?

[b]Hibernate version:[/b]
2.1.2

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseData.unsupportedConversion(Unknown Source)
at com.microsoft.jdbc.base.BaseData.getBlob(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getBlob(Unknown Source)
pmInstanceID: 1095317693156
at com.microsoft.jdbc.base.BaseResultSet.getBlob(Unknown Source)
at weblogic.jdbc.wrapper.ResultSet_com_microsoft_jdbc_base_BaseResultSet.getBlob(Unknown Source)
at com.wos.utils.log.StatusInformation.getInputParamXml(StatusInformation.java:1471)
at com.wos.runtime.InvokeInvoker.execute(InvokeInvoker.java:247)
at com.wos.runtime.SequenceInvoker.execute(SequenceInvoker.java:91)
at com.wos.runtime.ActivityThreadPeer.run(ActivityThreadPeer.java:128)
com.wos.faults.BPELException: Error unable to fetch input xml from data base [Microsoft][SQLServer 2000 Driver for JDBC]Unsuppo
rted data conversion. : [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion.
at com.wos.utils.log.StatusInformation.getInputParamXml(StatusInformation.java:1479)
at com.wos.runtime.InvokeInvoker.execute(InvokeInvoker.java:247)
at com.wos.runtime.SequenceInvoker.execute(SequenceInvoker.java:91)
at com.wos.runtime.ActivityThreadPeer.run(ActivityThreadPeer.java:128)
Sequence stop() called....
Process1222222222 stop() called....
Sequence Error -> Activity GetCountries1 encountered the following error Error unable to fetch input xml from data base [Micros
oft][SQLServer 2000 Driver for JDBC]Unsupported data conversion. : [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data c
onversion.

[b]Name and version of the database you are using:[/b]

sqlserver2000

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]

bertrand · **Posted:** Thu Sep 16, 2004 3:53 pm

Not sure this is the solution to your problem, but the JDBC driver shipped by Microsoft isn't the best you can use (it has some weird problem and very bad performance in some cases).

Try using JTDS ([url]jtds.sourceforge.net[/url])...

alin_sinpalean · **Posted:** Fri Sep 17, 2004 8:14 am

The MS driver doesn't support Blobs, that's why you get the exception. Try jTDS.

Alin.

bertrand · **Posted:** Fri Sep 17, 2004 4:06 pm

alin_sinpalean wrote:

The MS driver doesn't support Blobs, that's why you get the exception. Try jTDS.

True, cfr. http://www.hibernate.org/80.html

vaibhavmca2004 · **Posted:** Mon Sep 20, 2004 2:06 am

weblogic8.1 gives error "<Connection Pool "jtds Server Pool" deployment failed with the following error: Cannot load driver class: net.sourceforge.jtds.jdbc.Driver.> ".have made changes in config.xml also and various other tweaks also but to no benifit.plz guide me.

vaibhavmca2004 · **Posted:** Mon Sep 20, 2004 2:07 am

weblogic8.1 gives error "<Connection Pool "jtds Server Pool" deployment failed with the following error: Cannot load driver class: net.sourceforge.jtds.jdbc.Driver.> ".have made changes in config.xml also and various other tweaks also but to no benifit.plz guide me.

vaibhavmca2004 · **Posted:** Mon Sep 20, 2004 2:10 am

weblogic8.1 gives error "<Connection Pool "jtds Server Pool" deployment failed with the following error: Cannot load driver class: net.sourceforge.jtds.jdbc.Driver.> ".have made changes in config.xml also and various other tweaks also but to no benifit.plz guide me.

bertrand · **Posted:** Mon Sep 20, 2004 4:21 am

Three posts with the same question ?

Make sure the jTDS jar is in your classpath...

vaibhavmca2004 · **Posted:** Mon Sep 20, 2004 4:42 am

i did append the following classpath line
C:\bea\user_projects\VCAB2_0\lib\jtds-0.9-rc2.jar;
but server is still giving the same error:
<Connection Pool "jtds Server Pool" deployment failed with the following error: Cannot load driver class: net.sourceforge.jtds.jdbc.Driver.>

bertrand · **Posted:** Mon Sep 20, 2004 5:59 am

Very strange...

Are you sure you don't have any other exception prior this one ?
Can you check the integrity of the jTDS jar file ?
Can you load the jTDS driver class yourself (via a Class.forName()) - just to make sure it is actually available in your classpath ?

vaibhavmca2004 · **Posted:** Mon Sep 20, 2004 6:33 am

there r no exceptions before this error and also i checked the integrity of the jar.

bertrand · **Posted:** Mon Sep 20, 2004 6:46 am

Can you load the jTDS driver class yourself (via a Class.forName()) - just to make sure it is actually available in your classpath ?

According to me, you have a configuration problem somewhere that prevents you from accessing the classes of the jTDS jar file (I may be wrong, but the symptoms you explain let me think of this)...

christian · **Posted:** Mon Sep 20, 2004 6:57 am

Or call BEA.