wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 30057
    
149

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: crazy sql exception! code works on other machine but doesn't work on mine
 
Similar Threads
two ResultSet for one connection
please help in setting db connection in jboss
stored procedures in a loop... what gives?
Getting SQL Exception although stored procedure is correct!!!
Connecting To Database