You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Pugh, Eric" <EP...@MuseumCompany.com> on 2002/01/09 19:05:33 UTC

RE: Microsoft Jdbc

Hi all,

I wanted to followup on the earlier post about MS JDBC driver..  I tried to
drop it in, but got this stack trace..  If I get time, I will try and tackle
tracing the problems...  Has anyone else successfully implemented it?


[Wed Jan 09 12:08:30 EST 2002] -- INFO -- IDBroker thread was started.
[Wed Jan 09 12:08:30 EST 2002] -- WARN -- IDBroker is being used with db:
defaul
t
 which does not support transactions.  It is possible to
 generate duplicate keys, if multiple JVM's are used or other
 means are used to write to the database.
[Wed Jan 09 12:08:30 EST 2002] -- ERROR -- BasePeer.MapBuilder failed trying
to
instantiate: com.museumcompany.db.mccatalog.om.map.EmployeeMapBuilder
        Exception:  org.apache.turbine.util.TurbineException: Database type
com.
microsoft.jdbc.sqlserver.SQLServerDriver not implemented.
        Stack Trace follows:
        java.lang.InstantiationException: Database type
com.microsoft.jdbc.sqlse
rver.SQLServerDriver not implemented.
        at
org.apache.turbine.util.db.adapter.DBFactory.create(DBFactory.java:17
2)
        at
org.apache.turbine.services.db.TurbineMapBrokerService.getDatabaseMap
(TurbineMapBrokerService.java:170)
rethrown as org.apache.turbine.util.TurbineException: Database type
com.microsof
t.jdbc.sqlserver.SQLServerDriver not implemented.
        at
org.apache.turbine.services.db.TurbineMapBrokerService.getDatabaseMap
(TurbineMapBrokerService.java:179)
        at
org.apache.turbine.services.db.TurbineDB.getDatabaseMap(TurbineDB.jav
a:142)
        at
com.museumcompany.db.mccatalog.om.map.EmployeeMapBuilder.doBuild(Empl
oyeeMapBuilder.java:78)
        at
org.apache.turbine.om.peer.BasePeer.getMapBuilder(BasePeer.java:1845)

        at
com.museumcompany.db.mccatalog.om.BaseEmployeePeer.<clinit>(BaseEmplo
yeePeer.java:34)
        at
com.museumcompany.turbine.om.security.peer.TurbineUserPeer.retrieve(T
urbineUserPeer.java:134)
        at
com.museumcompany.turbine.services.security.db.DBUserManager.retrieve
(DBUserManager.java:148)
        at
com.museumcompany.turbine.services.security.BaseSecurityService.getAu
thenticatedUser(BaseSecurityService.java:236)
        at
com.museumcompany.turbine.services.security.TurbineSecurity.getAuthen
ticatedUser(TurbineSecurity.java:137)
        at
com.museumcompany.turbine.modules.actions.LoginUser.doPerform(LoginUs
er.java:134)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Ve
locityActionEvent.java:166)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(Velocity
ActionEvent.java:114)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAct
ion.java:114)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
        at org.apache.turbine.Turbine.doGet(Turbine.java:393)
        at org.apache.turbine.Turbine.doPost(Turbine.java:537)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:565)
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:355)
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:292)
        at
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:421)
        at
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.jav
a:215)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:255)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:225)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2252)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:164)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
446)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:163)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:875)
        at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:952)
        at java.lang.Thread.run(Thread.java:484)

[Wed Jan 09 12:08:30 EST 2002] -- ERROR --
        Exception:  org.apache.turbine.util.security.DataBackendException:
Faile
d to retrieve user 'epugh': Database type
com.microsoft.jdbc.sqlserver.SQLServer
Driver not implemented.
        Stack Trace follows:
        org.apache.turbine.util.security.DataBackendException: Failed to
retriev
e user 'epugh': Database type com.microsoft.jdbc.sqlserver.SQLServerDriver
not i
mplemented.
        at
com.museumcompany.turbine.services.security.db.DBUserManager.retrieve
(DBUserManager.java:151)
        at
com.museumcompany.turbine.services.security.BaseSecurityService.getAu
thenticatedUser(BaseSecurityService.java:236)
        at
com.museumcompany.turbine.services.security.TurbineSecurity.getAuthen
ticatedUser(TurbineSecurity.java:137)
        at
com.museumcompany.turbine.modules.actions.LoginUser.doPerform(LoginUs
er.java:134)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Ve
locityActionEvent.java:166)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(Velocity
ActionEvent.java:114)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAct
ion.java:114)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
        at org.apache.turbine.Turbine.doGet(Turbine.java:393)
        at org.apache.turbine.Turbine.doPost(Turbine.java:537)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:565)
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:355)
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:292)
        at
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:421)
        at
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.jav
a:215)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:255)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:225)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2252)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:164)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
446)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:163)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:875)
        at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:952)
        at java.lang.Thread.run(Thread.java:484)

[Wed Jan 09 12:08:30 EST 2002] -- ERROR --
        Exception:  org.apache.turbine.util.security.DataBackendException:
Faile
d to retrieve user 'epugh': Database type
com.microsoft.jdbc.sqlserver.SQLServer
Driver not implemented.
        Stack Trace follows:
        org.apache.turbine.util.security.DataBackendException: Failed to
retriev
e user 'epugh': Database type com.microsoft.jdbc.sqlserver.SQLServerDriver
not i
mplemented.
        at
com.museumcompany.turbine.services.security.db.DBUserManager.retrieve
(DBUserManager.java:151)
        at
com.museumcompany.turbine.services.security.BaseSecurityService.getAu
thenticatedUser(BaseSecurityService.java:236)
        at
com.museumcompany.turbine.services.security.TurbineSecurity.getAuthen
ticatedUser(TurbineSecurity.java:137)
        at
com.museumcompany.turbine.modules.actions.LoginUser.doPerform(LoginUs
er.java:134)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Ve
locityActionEvent.java:166)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(Velocity
ActionEvent.java:114)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAct
ion.java:114)
        at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
        at org.apache.turbine.Turbine.doGet(Turbine.java:393)
        at org.apache.turbine.Turbine.doPost(Turbine.java:537)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:565)
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:355)
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:292)
        at
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServl
et.java:421)
        at
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.jav
a:215)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:255)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:225)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2252)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:164)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
446)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:163)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

        at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:875)
        at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:952)
        at java.lang.Thread.run(Thread.java:484)

[Wed Jan 09 12:58:48 EST 2002] -- WARN -- IDBroker is being used with db:
defaul
t
 which does not support transactions.  It is possible to
 generate duplicate keys, if multiple JVM's are used or other
 means are used to write to the database.


Eric Pugh



-----Original Message-----
From: Pugh, Eric [mailto:EPugh@MuseumCompany.com]
Sent: Thursday, November 29, 2001 10:37 AM
To: 'Turbine Users List'
Subject: RE: Microsoft Jdbc


I have only used the sun provided JDBC ODBC bridge with SQL server, although
it has worked great for me.  I know some people say they are buggy.  I plan
(at some point) at looking at Microsofts JDBC driver, but I am waiting till
it is out of beta..

Eric

-----Original Message-----
From: pask@acn.gr [mailto:pask@acn.gr]
Sent: Thursday, November 29, 2001 2:15 AM
To: turbine-user@jakarta.apache.org
Subject: Microsoft Jdbc



Hi
Has anybody tried the Microsofts jdbc driver for sqlserver
I get Instatiation Exception when  i try to use it not at startup
but when i get The connection in the code
I think the error comes from the adaptor in the
Turbine Resources.

Any ideas


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>