• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

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

 
Greenhorn
Posts: 8
  • 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 ]
 
author and iconoclast
Posts: 24203
43
Mac OS X Eclipse IDE Chrome
  • 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
  • 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?
 
author & internet detective
Posts: 40282
819
Eclipse IDE VI Editor Java
  • 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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have started using JDBC drivers instead of Bridge.....
problem is resolved now
 
The moth suit and wings road is much more exciting than taxes. Or this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic