JDBC Drivers for SQL Server ( Cocoon 2.0.2 & JDK 1.4 ) ?????

[Jason Uithol <ja...@datacodex.net>]

Hello,

I have read a few posts regarding JDBC Drivers on this group but I am still
having problems.

I have been using Cocoon 2.0.1 & JDK1.3 just fine for about a year.  I
started using the JTurbo drivers, and lately, the drivers available from
Microsoft.

When I upgraded to Cocoon2.0.2 & JDK1.4 I got the stack trace included
below.  I have several connections configured in my cocoon.xconf, much like
this:

		<jdbc name="myDatasource">
			<pool-controller min="1" max="1"/>

<dburl>jdbc:microsoft:sqlserver://myServer:1433;databasename=myDatabaseName<
/dburl>
			<user>myUsername</user>
			<password>myPassword</password>
		</jdbc>

In my WEB-INF/web.xml I have a load-class param for the driver class:

    <init-param>
      <param-name>load-class</param-name>
      <param-value>
        <!-- For Database Driver: -->

		  com.microsoft.jdbc.sqlserver.SQLServerDriver

      </param-value>
    </init-param>


And I have the msutil.jar, mssqlserver.jar and msbase.jar in my WEB-INF
directory.



This worked just fine before.  What has happened ?


Thanks in advance,


Jason Uithol
Data Technologist
DatacodeX Pty Ltd
jason@datacodex.com
http://www.datacodex.com


P.S. The new JTurbo drivers are delivered with a self-extracting shell
script that uses a graphical environment ;[

So I haven't tried them out.  I know this is a silly question but are there
any _open source_ JDBC drivers for sql server ?



STACKTRACE ( some of it )
=========================


Cocoon 2 - Internal server error

----------------------------------------------------------------------------
----

type fatal

message Exception in ServerPagesGenerator.generate()

description org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get
the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available

sender org.apache.cocoon.servlet.CocoonServlet

source Cocoon servlet

request-uri

/ejbgen/ozhealth/list

path-info

ozhealth/list

stack-trace

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get
the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available
	at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:272)
	at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(Abstract
EventPipeline.java:166)
	at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(Abstrac
tStreamPipeline.java:192)
	at
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(Seri
alizeNode.java:153)

(snip - just Tree processor stack )

	at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:293)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)

( snip - just Catalina application pipeline stuff )

	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
1011)
	at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106
)
	at java.lang.Thread.run(Thread.java:536)


Caused by: java.lang.RuntimeException: Could not get the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available
	at
org.apache.cocoon.www.ejbgenerator.cmp.getSchema.getschema_ozhealth_xsp.gene
rate(/usr/local/websites/generator.202/work/localhost/ejbgen/cocoon-files/or
g/apache/cocoon/www/ejbgenerator/cmp/getSchema/getschema_ozhealth_xsp.java:3
81)
	at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:260)
	... 53 more
java.lang.RuntimeException: Could not get the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available
	at
org.apache.cocoon.www.ejbgenerator.cmp.getSchema.getschema_ozhealth_xsp.gene
rate(/usr/local/websites/generator.202/work/localhost/ejbgen/cocoon-files/or
g/apache/cocoon/www/ejbgenerator/cmp/getSchema/getschema_ozhealth_xsp.java:3
81)
	at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:260)
	at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(Abstract
EventPipeline.java:166)
	at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(Abstrac
tStreamPipeline.java:192)

( snip - same as above )







---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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