• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 24207
46
Mac OS X Eclipse IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have started using JDBC drivers instead of Bridge.....
problem is resolved now
 
reply
    Bookmark Topic Watch Topic
  • New Topic