Hi,
Thanks for your help. It brought me one step further but did not yet
solve the problem! It looks like the context.xml is mandatory. I moved
the configuration from the server.xml to the context.xml. The error
message changed as follows:
org.apache.jasper.JasperException: Unable to get connection, DataSource invalid:
"org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class
'ianywhere.ml.jdbcodbc.IDriver'"
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
This means it does not find the driver jar file. I put it in all
possible directories (lib directories of the webapp, tomcats common/lib
and shared/lib) but all without success. Do I have to set a CLASSPATH
somewhere??
Tom
Hadraba Petr wrote:
Hi,
I'm not using Sybase under Tomcat; I have PostgreSQL...
Eclipse? My configuration is, Eclipse does not modify Tomcat
configuration (this is the default)
In your WebContent under META-INF create context.xml with the
<Resource ... /> definition. The <Context /> element does not require
any attributes:
<Context>
<Resource ... your="attributes" ... />
</Context>
And finaly, place the JDBC driver JAR into your WEB-INF lib.
Catalina will automaticaly load your driver. My configuration is
working properly.
This configuration is working for me fine!
JNDI names? Look at the JNDI section in the J2EE Tutorial in the Sun's
web site. The examples are very helpful.
There is also another question:
It's good solution to place JDBC driver into the webapp's lib directory?
Hope it helps
PETR
PS.: My Adaptive Server Enterprise 15 is working good, but not under
Tomcat; it's standalone application... The initialization, driver URL
was taken from the Sybase's JDBC documentation on their web sites.
On 3/3/06, Tom Bednarz <[EMAIL PROTECTED]> wrote:
I try to configure a JDBC DataSource for my Adaptive Server Anywhere 9
database. Unfortunately without any success so far!
I use Tomcat 5.5.18.
The error is well known and looks as follows:
org.apache.jasper.JasperException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'"
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
I use the JDBCODBC driver to connect. Here is the configuration:
server.xml
<Resource
name="jdbc/MyService"
type="javax.sql.DataSource"
password="sql"
driverClassName="ianywhere.ml.jdbcodbc.IDriver"
maxIdle="2"
maxWait="5000"
validationQuery="select * from CodeTable"
username="dba"
url="jdbc:odbc:dsn=MyService"
maxActive="50"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
Web.xml
<resource-ref>
<description>Database connection</description>
<res-ref-name>jdbc/MyService</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Note: I currently do NOT deplay using a WAR file since I use Eclipse as
develpment environment to debug etc. So I do NOT have an application
specific context.xml file at the moment.
Could anybody please explain what needs to be put into the name
property? It seems that jdbc/ is mandatory but what needs to follow the
slash is not clear to me! Is it the ODBC datasource name, the database
name or any choosen name??
Many thanks for your help.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
