You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Christian SCHRÖTER <ch...@nbg.sbs.de> on 2002/02/11 09:08:56 UTC
MSSQLServer & Connectionpool: What must i do so that it works?
Hi,
im still using Cocoon 1.8.2 and now i must connect to a MSSQLServer.
I copied this three MS-files into the lib-dir of tomcat.
If i open the conncetion in my xml-File like this:
<esql:driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</esql:driver>
<esql:dburl>jdbc:microsoft:sqlserver://aaa.bbb.ccc.ddd:1433;database=xxx_yyy</esql:dburl>
<esql:username>test</esql:username>
<esql:password>test</esql:password>
It works fine.
But now, when i want to use the Conncetionpool i get this error-messege:
java.lang.RuntimeException: Error opening pooled connection: stsdc: Database
type com.microsoft.jdbc.sqlserver.SQLServerDriver not implemented.
at
_remote._debxxx._xxx._xxx._xxx._www_xxx._debug._yyyy._yyyy.populateDocument(_lekj.java:5125)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
at org.apache.cocoon.Engine.handle(Engine.java:384)
at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:806)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
In cocoon.properties i have written:
processor.xsp.pool.database.stsdc.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
processor.xsp.pool.database.stsdc.url=jdbc:microsoft:sqlserver://aaa.bbb.ccc.ddd:1433;database=mib_sql
processor.xsp.pool.database.stsdc.username=test
processor.xsp.pool.database.stsdc.password=test
processor.xsp.pool.database.stsdc.maxConnections=3
processor.xsp.pool.database.stsdc.expiryTime=3600000
# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
processor.xsp.pool.database.adaptor=DBms,DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMySQL
processor.xsp.pool.database.adaptor.DBms=com.microsoft.jdbc.sqlserver.SQLServerDriver
Can somebody help, please...
cu,
Christian
--
------------------------------------------------------------
Schröter, Christian
Siemens Business Services GmbH & Co. OHG
SBS D BS ECS 3
Tel.: +49 911 654 2355
Fax: +49 911 654 2108
eMail: Christian.Schroeter@nbg.sbs.de
------------------------------------------------------------
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MSSQLServer & Connectionpool: What must i do so that it works?
Posted by heli <he...@gmx.at>.
Christian SCHRÖTER wrote:
> Hi,
>
> im still using Cocoon 1.8.2 and now i must connect to a MSSQLServer.
> I copied this three MS-files into the lib-dir of tomcat.
> If i open the conncetion in my xml-File like this:
>
> <esql:driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</esql:driver>
> <esql:dburl>jdbc:microsoft:sqlserver://aaa.bbb.ccc.ddd:1433;database=xxx_yyy</esql:dburl>
> <esql:username>test</esql:username>
> <esql:password>test</esql:password>
>
> It works fine.
>
> But now, when i want to use the Conncetionpool i get this error-messege:
>
> java.lang.RuntimeException: Error opening pooled connection: stsdc: Database
> type com.microsoft.jdbc.sqlserver.SQLServerDriver not implemented.
> at
--cut---
> Can somebody help, please...
>
> cu,
> Christian
>
>
as far as i know it from cocoon 2 you have to add the driver in the cocoon.xconf
look at http://www.galatea.com/flashguides/cocoon-tips-2.xml
bye
heli
--
__ __ __ __ __ __ _ __
/ // /__ / /_ _ __ __/ /_ / // /__ (_)__/ /__ ___ ____ ____ ____
/ _ / -_) / ' \/ // / __/ / _ / -_) / _ / -_) _ `/ _ `/ -_) __/
/_//_/\__/_/_/_/_/\_,_/\__/ /_//_/\__/_/\_,_/\__/\_, /\_, /\__/_/
/___//___/
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>