aspose file tools*
The moose likes JDBC and the fly likes crazy sql exception! code works on other machine but doesn't work on mine Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "crazy sql exception! code works on other machine but doesn Watch "crazy sql exception! code works on other machine but doesn New topic
Author

crazy sql exception! code works on other machine but doesn't work on mine

Vinayachandra Acharya
Greenhorn

Joined: Nov 16, 2004
Posts: 8
I am getting a SQL Exception while calling a stored procedure. But with the same code on the other machine it runs properly without any exceptions!!! I am using SQL Server and i am using jdbcdbc bridge driver for the connection. What may be the problem in my system? I am using JBoss Application Server I am puzzled by the fact that same code on same version of jboss works well with this stored procedure... There is no problem with other stored procedure i.e i am able to conect to the database and can execute other stored procedure :-(

2004-11-22 15:04:07,607 INFO [STDOUT] SQLException in STT_Beans.STT_EntityBeans.SearchListEntity.loadTeamMembersRequests(): [Microsoft][ODBC SQL Server Driver][SQL Server]vijayasekar.subramaniam 2004-11-22 15:04:07,617 ERROR [STDERR] java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]vijayasekar.subramaniam 2004-11-22 15:04:07,617 ERROR [STDERR] at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106) 2004-11-22 15:04:07,627 ERROR [STDERR] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)

[edited to disable smilies]
[ November 23, 2004: Message edited by: Jeanne Boyarsky ]
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24183
    
  34

Perhaps you're using a different version of the JDBC-ODBC bridge on the two machines.


[Jess in Action][AskingGoodQuestions]
Vinayachandra Acharya
Greenhorn

Joined: Nov 16, 2004
Posts: 8
Thanks for the reply....
But how to determine the version of the JDBC-ODBC bridge and how upgrade it?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30309
    
150

The bridge is the jar/zip file that you put in the classpath when you compile and run.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Vinayachandra Acharya
Greenhorn

Joined: Nov 16, 2004
Posts: 8
I have started using JDBC drivers instead of Bridge.....
problem is resolved now
 
 
subject: crazy sql exception! code works on other machine but doesn't work on mine