JDBC & Firewall - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

JDBC & Firewall

JDBC & Firewall# Java - 爪哇娇娃

b*d2003-10-01 07:10

1 楼

I used to use JDBC to connect to SQL server. It worked well. Recently, I
reinstalled my computer(including Jdk1.3 Microsoft SQL 2000 Jdbc driver), and
firewall is stalled into the server with SQL database.
When I run the Java program, it can not work. The error messages are as
follows:
I wonder if the server is configured with firewall, can I still use the JDBC
to access the server?
Thanks a lot!
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[

f*h2003-10-01 07:10

2 楼

it seems the jvm can't find the jdbc driver. make sure it is in your classpath.

【在 b*********d 的大作中提到】

: I used to use JDBC to connect to SQL server. It worked well. Recently, I
: reinstalled my computer(including Jdk1.3 Microsoft SQL 2000 Jdbc driver), and
: firewall is stalled into the server with SQL database.
: When I run the Java program, it can not work. The error messages are as
: follows:
: I wonder if the server is configured with firewall, can I still use the JDBC
: to access the server?
: Thanks a lot!
: DriverManager.initialize: jdbc.drivers = null
: JDBC DriverManager initialized

m*t2003-10-01 07:10

3 楼

classpath.
I think his jdbc driver is fine, as you can see in the log message it's
registered and instantiated. The NoClassDefError was caused by something else
(which is weird indeed).
To bigbaldhead, looks like you have to punch a hole in your firewall for port
1433. You might want to reconsider your architecture, though. It's not a
good idea to expose your db server.
JDBC
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
[...]

【在 f********h 的大作中提到】

: it seems the jvm can't find the jdbc driver. make sure it is in your classpath.

w*c2003-10-01 07:10

4 楼

look for msutil.jar and make sure it's in ur classpath or ext dir

and
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd

【在 b*********d 的大作中提到】

b*d2003-10-01 07:10

5 楼

I check it again and find msutil.jar msbase.jar mssqlserver.jar are all in the
classpath.

JDBC
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown

【在 w********c 的大作中提到】

: look for msutil.jar and make sure it's in ur classpath or ext dir
:
: and
: driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
: DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
: driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd

b*d2003-10-01 07:10

6 楼

I reinstall SQL Jdbc driver and set the classpath again. Now that part works,
but I have the new problem.
Thank everyone.

the
driver),
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd

【在 b*********d 的大作中提到】

: I check it again and find msutil.jar msbase.jar mssqlserver.jar are all in the
: classpath.
:
: JDBC
: driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
: DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
: driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
: com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown