Have downloaded & am trying to use (tight deadline though) the new microsoft
sqlserver jdbc driver. Running on win 2000 & trying to connect to sqlserver
.
Connection attempt causes
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
error
Having a problem when trying to make connection in a servlet (exact same
code works in an ordinary class but not in my servlet - may be calling
something slightly wrong!!)
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn =
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;datab
asename=testDB","sa","sa");
The call to the getConnection always returns a
com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
error
ANy ideas anyone?? - think it could be to do with the // in the parameters
Could you post the full stack trace rather just the error message?
--
Jon Skeet - <sk...@pobox.com>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
Did you check the official newsgroup for this beta ?
news://msnews.microsoft.com/microsoft.public.sqlserver.jdbcdriver
Matthias
--
Matthias Ernst - SoftwareIngenieur
CoreMedia AG - http://www.coremedia.com - 0700-COREMEDIA
Visit us at
* Buchmesse, Frankfurt, 1.1/C1113 (at DWS)
* Systems, Munich, C1.330
(Using jRun 3.0)...
10/10 12:09:38 info (JRun) invoker: init
10/10 12:09:39 error (JRun) Error loading directories
[java.util.zip.ZipException: invalid EXT descriptor signature]
java.util.zip.ZipException: invalid EXT descriptor signature
at java.util.zip.ZipInputStream.readEnd(Unknown Source)
at java.util.zip.ZipInputStream.read(Unknown Source)
at java.util.zip.ZipInputStream.closeEntry(Unknown Source)
at java.util.zip.ZipInputStream.getNextEntry(Unknown Source)
at
allaire.jrun.resource.JarResource.loadDirectories(../resource/JarResource.ja
va:193)
at
allaire.jrun.resource.JarResource.<init>(../resource/JarResource.java:78)
at
allaire.jrun.resource.JarResource.<init>(../resource/JarResource.java:49)
at
allaire.jrun.resource.JarResource.<init>(../resource/JarResource.java:30)
at
allaire.jrun.servlet.JRunResourceManager.getResource(../servlet/JRunResource
Manager.java:154)
at
allaire.jrun.servlet.JRunResourceManager.getResource(../servlet/JRunResource
Manager.java:124)
at
allaire.jrun.servlet.JRunResourceManager.getResourceURL(../servlet/JRunResou
rceManager.java:191)
at allaire.jrun.servlet.JRunSE.getResource(../servlet/JRunSE.java:1457)
at
allaire.jrun.servlet.JRunServletLoader.getClassBytes(../servlet/JRunServletL
oader.java:623)
at
allaire.jrun.servlet.JRunServletLoader.loadClass(../servlet/JRunServletLoade
r.java:515)
at
allaire.jrun.servlet.JRunServletLoader.loadClass(../servlet/JRunServletLoade
r.java:444)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at servletDriverManager.init(servletDriverManager.java:27)
at
allaire.jrun.servlet.JRunServletLoader.loadServletInstance(../servlet/JRunSe
rvletLoader.java:236)
at
allaire.jrun.servlet.JRunServletLoader.loadServletInstance(../servlet/JRunSe
rvletLoader.java:190)
at
allaire.jrun.servlet.JRunServletLoader.loadServlet(../servlet/JRunServletLoa
der.java:177)
at
allaire.jrun.servlet.JRunSE.getServletReference(../servlet/JRunSE.java:1267)
at
allaire.jrun.servlet.JRunSE.getNamedDispatcher(../servlet/JRunSE.java:1537)
at allaire.jrun.servlet.Invoker.service(../servlet/Invoker.java:64)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDis
patcher.java:88)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1131)
at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:330)
at allaire.jrun.http.WebEndpoint.run(../http/WebEndpoint.java:107)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
"Jon Skeet" <sk...@pobox.com> wrote in message
news:MPG.162e396fa...@mrmog.peramon.com...
I suggest you try it *not* using JRun to start with then. First rule of
debugging: make your test case as simple as possible.
Turns out there's a known 'bug' in the microsoft jdbc driver (ie the jar can
appear corrupted to some class loaders) which caused the zip exception...
However, wrote a 20 line piece of code to connect to the db in a non-servlet
env, this worked so now know its a jRun 3.0 issue!!
"Jon Skeet" <sk...@pobox.com> wrote in message
news:MPG.162e4b135...@mrmog.peramon.com...