Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...
Java Forum / Databases / November 2003

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail AlertsStart New Thread
- 20 Nov 2003 02:32 GMT
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","");
Reply to this Message
Sarb Singh - 21 Nov 2003 09:35 GMT
 2003-11-21 15:03:18 - ServerXmlReader: Config=$TOMCAT_HOME\conf\server.xml
 2003-11-21 15:03:18 - PathSetter:
home=D:\Server\tomcat3\jakarta-tomcat-3.3.1a
 2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOME\conf\apps-12
 7.0.0.1.xml
 2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOME\conf\apps-ad
 min.xml
 2003-11-21 15:03:18 - ContextXmlReader: Context
config=$TOMCAT_HOME\conf\apps-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:\Server\tomcat3\jakarta-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)
 > 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","");
Reply to this Message
- 21 Nov 2003 13:27 GMT
Sarb,

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

Niels

>   2003-11-21 15:03:18 - ServerXmlReader: Config=$TOMCAT_HOME\conf\server.xml
>   2003-11-21 15:03:18 - PathSetter:
[quoted text clipped - 33 lines]
>           at java.security.AccessController.doPrivileged(Native Method)
>           at
org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
> Sourc
>   e)
[quoted text clipped - 30 lines]
>           at java.security.AccessController.doPrivileged(Native Method)
>           at
org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
> Sourc
>   e)
[quoted text clipped - 25 lines]
>           at java.security.AccessController.doPrivileged(Native Method)
>           at
org.apache.tomcat.util.compat.Jdk12Support.doPrivileged(Unknown
> Sourc
>   e)
[quoted text clipped - 17 lines]
>   > 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)
>   >
[quoted text clipped - 4 lines]
>   > 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)
>   >
[quoted text clipped - 11 lines]
>   >
>   > conn = DriverManager.getConnection(url,"sa","");
Reply to this Message
Pete Bennett - 26 Nov 2003 13:38 GMT
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
> 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)
>
[quoted text clipped - 3 lines]
>
> 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)
>
[quoted text clipped - 10 lines]
>
> conn = DriverManager.getConnection(url,"sa","");
Reply to this Message
- 26 Nov 2003 15:57 GMT
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

> 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.
[quoted text clipped - 8 lines]
> > 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)
> >
[quoted text clipped - 3 lines]
> >
> > 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)
> >
[quoted text clipped - 5 lines]
> > 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","");
Reply to this Message


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.