SQL Server 2000 database connection problems: Can ANY one help?  
Author Message
nielskistrup





PostPosted: 2003-11-20 10:33:00 Top

java-programmer, SQL Server 2000 database connection problems: Can ANY one help? 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","");



 
Pete Bennett





PostPosted: 2003-11-26 21:39:00 Top

java-programmer >> SQL Server 2000 database connection problems: Can ANY one help?
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.
<email***@***.com> wrote in message
news:email***@***.com...
> 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","");
>
>
>


 
nkistrup





PostPosted: 2003-11-26 23:57:00 Top

java-programmer >> SQL Server 2000 database connection problems: Can ANY one help? 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" <email***@***.com> wrote in message
news:3fc4ad1b$0$24064$email***@***.com...
>
> 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.
> <email***@***.com> wrote in message
> news:email***@***.com...
> > 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","");
> >
> >
> >
>
>