File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Vinayachandra Acharya
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 24204
34
Chrome Eclipse IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Perhaps you're using a different version of the JDBC-ODBC bridge on the two machines.
 
Vinayachandra Acharya
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply....
But how to determine the version of the JDBC-ODBC bridge and how upgrade it?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The bridge is the jar/zip file that you put in the classpath when you compile and run.
 
Vinayachandra Acharya
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have started using JDBC drivers instead of Bridge.....
problem is resolved now
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic