AppletTalk.com

Guest

Environment: SQL Server 2000, Windows 2000, Eclipse, and Microsoft's SQL
Server 2000 driver for JDBC
Problem: Connection to any table in my SQL 2000 database hangs. If I stop
it, it produces the following exception:
com.sun.jdi.VMDisconnectedException: Got IOException from Virtual Machine
at
org.eclipse.jdi.internal.connect.PacketReceiveManager.getReply(PacketReceive
Manager.java(Compiled Code))

at
org.eclipse.jdi.internal.connect.PacketReceiveManager.getReply(PacketReceive
Manager.java:137)

at org.eclipse.jdi.internal.MirrorImpl.requestVM(MirrorImpl.java:168)

at org.eclipse.jdi.internal.MirrorImpl.requestVM(MirrorImpl.java:186)

at
org.eclipse.jdi.internal.ObjectReferenceImpl.invokeMethod(ObjectReferenceImp
l.java:350)

at
org.eclipse.jdt.internal.debug.core.model.JDIThread.invokeMethod(JDIThread.j
ava:647)

at
org.eclipse.jdt.internal.debug.core.model.JDIObjectValue.sendMessage(JDIObje
ctValue.java:67)

at
org.eclipse.jdt.internal.debug.eval.LocalEvaluationEngine.run(LocalEvaluatio
nEngine.java:231)

at
org.eclipse.jdt.internal.debug.core.model.JDIThread.runEvaluation(JDIThread.
java:562)

at
org.eclipse.jdt.internal.debug.eval.LocalEvaluationEngine.acceptClassFiles(L
ocalEvaluationEngine.java:218)

at
org.eclipse.jdt.internal.core.eval.RequestorWrapper.acceptClassFiles(Request
orWrapper.java:45)

at
org.eclipse.jdt.internal.eval.EvaluationContext.evaluate(EvaluationContext.j
ava:234)

at
org.eclipse.jdt.internal.eval.EvaluationContext.evaluate(EvaluationContext.j
ava:252)

at
org.eclipse.jdt.internal.core.eval.EvaluationContextWrapper.evaluateCodeSnip
pet(EvaluationContextWrapper.java:207)

at
org.eclipse.jdt.internal.debug.eval.LocalEvaluationEngine$1.run(LocalEvaluat
ionEngine.java:433)

at java.lang.Thread.run(Thread.java:498)

I have confirmed that server name is correct, and have pinged the port.
Looking at the following code snippet, what I am doing wrong?

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url =
"jdbc:microsoft:sqlserver://niels-bngjqb9y1:1433;DatabaseName=Forester;";

Connection conn = null;

conn = DriverManager.getConnection(url,"sa","");

Sarb Singh · Guest

2003-11-21 15:03:18 - ServerXmlReader: Config=$TOMCAT_HOMEconfserver.xml
2003-11-21 15:03:18 - PathSetter:
home=D:Servertomcat3jakarta-tomcat-3.3.1a
2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOMEconfapps-12
7.0.0.1.xml
2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOMEconfapps-ad
min.xml
2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOMEconfapps-ex
amples.xml
2003-11-21 15:03:18 - AutoWebApp: Loaded from config: DEFAULT:/admin
EmbededTomcat: exception initializing ContextManager
java.lang.NoSuchMethodError
at
org.apache.tomcat.facade.JspInterceptor.addContext(JspInterceptor.jav
a:269)
at
org.apache.tomcat.core.ContextManager.fireAddContext(ContextManager.j
ava:613)
at
org.apache.tomcat.core.ContextManager.init(ContextManager.java:588)
at
org.apache.tomcat.startup.EmbededTomcat.initContextManager(EmbededTom
cat.java:564)
at
org.apache.tomcat.startup.EmbededTomcat.execute1(EmbededTomcat.java:7
03)
at
org.apache.tomcat.startup.EmbededTomcat$1.run(EmbededTomcat.java:687)

at
org.apache.tomcat.util.compat.Jdk12Support$PrivilegedProxy.run(Unknow
n Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
Sourc
e)
at
org.apache.tomcat.startup.EmbededTomcat.execute(EmbededTomcat.java:68
5)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.tomcat.util.IntrospectionUtils.execute(IntrospectionUtils.
java:87)
at org.apache.tomcat.startup.Main.execute(Main.java:313)
at org.apache.tomcat.startup.Main.main(Main.java:140)
2003-11-21 15:03:18 - AutoWebApp: Auto-Adding DEFAULT:/
2003-11-21 15:03:18 - AutoWebApp: Loaded from config: DEFAULT:/examples
2003-11-21 15:03:18 - ContextManager: Tomcat configured and in stable
state
Guessed home=D:Servertomcat3jakarta-tomcat-3.3.1a
Exception: java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException:
org.apache.tomcat.core.TomcatExcept
ion: EmbededTomcat.initContextManager
at
org.apache.tomcat.startup.EmbededTomcat.initContextManager(EmbededTom
cat.java:570)
at
org.apache.tomcat.startup.EmbededTomcat.execute1(EmbededTomcat.java:7
03)
at
org.apache.tomcat.startup.EmbededTomcat$1.run(EmbededTomcat.java:687)

at
org.apache.tomcat.util.compat.Jdk12Support$PrivilegedProxy.run(Unknow
n Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
Sourc
e)
at
org.apache.tomcat.startup.EmbededTomcat.execute(EmbededTomcat.java:68
5)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.tomcat.util.IntrospectionUtils.execute(IntrospectionUtils.
java:87)
at org.apache.tomcat.startup.Main.execute(Main.java:313)
at org.apache.tomcat.startup.Main.main(Main.java:140)
Root Exception: org.apache.tomcat.core.TomcatException:
EmbededTomcat.initContex
tManager
org.apache.tomcat.core.TomcatException: EmbededTomcat.initContextManager
at
org.apache.tomcat.startup.EmbededTomcat.initContextManager(EmbededTom
cat.java:570)
at
org.apache.tomcat.startup.EmbededTomcat.execute1(EmbededTomcat.java:7
03)
at
org.apache.tomcat.startup.EmbededTomcat$1.run(EmbededTomcat.java:687)

at
org.apache.tomcat.util.compat.Jdk12Support$PrivilegedProxy.run(Unknow
n Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
Sourc
e)
at
org.apache.tomcat.startup.EmbededTomcat.execute(EmbededTomcat.java:68
5)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.tomcat.util.IntrospectionUtils.execute(IntrospectionUtils.
java:87)
at org.apache.tomcat.startup.Main.execute(Main.java:313)
at org.apache.tomcat.startup.Main.main(Main.java:140)

<nielskistrup (AT) comcast (DOT) net> wrote

Guest

Sarb,

I don't understand your response: What's the solution to my connection
problem?

Niels

"Sarb Singh" <sarbs_exeige (AT) hotmail (DOT) com> wrote

Pete Bennett · Guest

Have you considered using a different driver? There are some very good
type 4 drivers out there, albeit with the usual type 4 performance overhead.
I have used the IBM branded ones with WebSphere very successfully in
production from time to time.

Pete Bennett
Distributed Systems Professional Services.
<nielskistrup (AT) comcast (DOT) net> wrote

Guest

THANKS Pete,

I figured out what the problem was (or could have been): A) Upgraded Eclipse
to version 2.1.2 (from 2.0), B) Created a user acct. for the database that I
was connecting to. This was a case of RTFM: Reading an ad for one of the
other JDBC drivers for SQL Server, Microsoft's driver does NOT support
Windows authentication . . . that's what I was doing.

Now the fun begins; literally. To make my life easier, can you (or anyone
reading this thread), recommend a good JDBC book. I'm coming from a strong
ADO & SQL Server background, so I know the basics (connection, command,
recordset, etc., etc. objects).

Niels

"Pete Bennett" <pete_bennett (AT) dsl (DOT) pipex.com> wrote