RE: JDBC and handling of errors
From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 03/17/04
- Next message: Mr.Smith: "Connection dropouts"
- Previous message: AAA: "Re:Triggers"
- In reply to: Kalle Dahlberg: "JDBC and handling of errors"
- Next in thread: Kalle Dahlberg: "RE: JDBC and handling of errors"
- Reply: Kalle Dahlberg: "RE: JDBC and handling of errors"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 03:28:04 GMT
Hi Kalle,
If I understand correctly you are working in a project which uses JDBC to
connect to an SQL Server and execute some stored procedures. However, some
SQLException cannot be thrown in the Java program. Based on my research,
this behavior seems like a problem in our MS SQL Server 2000 Driver for
JDBC driver. Currently, I am checking with our developers and I will post
my response at soon as I have update for you. The tests on my side are
below:
I created a stored procedure named "test" in the pubs database as below and
performed some testing with JDK 1.4.
CREATE PROCEDURE test AS
SELECT 1/0
GO
If I use our MS SQL Server 2000 Driver for JDBC driver (sp2) as below, the
exception is not thrown:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn =
DriverManager.getConnection("jdbc:microsoft:sqlserver://servername:1433;User
=sa;Password=123456789;DatabaseName=pubs");
Statement statement = conn.createStatement();
statement.execute("exec test");
However, if I change to use the JDBC for ODBC driver, the exception is
thrown correctly:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =
DriverManager.getConnection("jdbc:odbc:pubs","sa","123456789");
Statement statement = conn.createStatement();
statement.execute("exec test");
I also tested the third party driver [aveConnect 3.0 JDBC Driver for MS SQL
Server] downloaded from http://www.atinav.com/download.htm, and the
exception is also thrown correctly:
Class.forName("net.avenir.jdbc3.Driver");
Connection conn =
DriverManager.getConnection("jdbc:AvenirDriver://zyx2k05:1433/pubs;uid=sa;pw
d=123456789");
Statement statement = conn.createStatement();
statement.execute("exec test");
In addition, because this problem is mostly related the JDBC driver, if you
would, please post this question in the
microsoft.public.sqlserver.jdbcdriver newsgroup in the future. The
jdbcdriver newsgroup is primarily for issues involving JDBC Driver. The
reason why we recommend posting appropriately is you will get the most
qualified pool of respondents, and other partners who read the newsgroups
regularly can either share their knowledge or learn from your interaction
with us.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Mr.Smith: "Connection dropouts"
- Previous message: AAA: "Re:Triggers"
- In reply to: Kalle Dahlberg: "JDBC and handling of errors"
- Next in thread: Kalle Dahlberg: "RE: JDBC and handling of errors"
- Reply: Kalle Dahlberg: "RE: JDBC and handling of errors"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
