Hello,
I have to ask you once again. I have tried to get a connection to my
Sybaseserver. I get "no suitable driver" when trying to connect. Do anyone
have a suggestion on what is wrong. Sybase driver file jconn2.jar is placed
under $CATALINA/common/lib.
It is a long mail but I hope anyone will look at it.
- Terje
org.apache.jasper.JasperException: Unable to get connection, DataSource
invalid: "No suitable driver"
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
54)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
.....
I have an example that is working:
...
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.util.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"; %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql"; %>
<body>
<sql:setDataSource var="ex" scope="application"
driver="com.sybase.jdbc2.jdbc.SybDriver"
url="jdbc:sybase:Tds:xxxxx:4444"
user="uuuu"
password="pwdpwd"
/>
<sql:query var="rader" dataSource="${ex}" >
select Initialer
from Skytter
</sql:query>
Liste :<br>
<c:forEach items="${rader.rows}" var="rad">
<c:out value="${rad.Initialer}" /><br>
</c:forEach>
</body>
</html>
-----------------------------------------------------
And one that is not working.
.....
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.util.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"; %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql"; %>
<body>
<sql:setDataSource var="ex" scope="application"
dataSource="javax.sql.DataSource"
/>
<sql:query var="rader" dataSource="${ex}">
select Initialer
from Skytter
</sql:query>
<c:forEach items="${rader.rows}" var="rad">
<c:out value="${rad.Initialer}" /><br>
</c:forEach>
-----------------------------------------------------------
My web.xml is lik this.
<context-param>
<param-name>
javax.sql.DataSource
</param-name>
<param-value>
jdbc:sybase:Tds:xxxxxx:4444,com.sybase.jdbc2.jdbc.SybDriver,uuuu,pwdpwd
</param-value>
</context-param>
-------------- OR LIKE THIS
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/resDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
--------------------------------------------------
server.xml
<Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="0" displayName="dbtest"
docBase="c:\usr\utvikl\dbtest"
mapperClass="org.apache.catalina.core.StandardContextMapper" path="/dbtest"
privileged="false" reloadable="true" swallowOutput="false" useNaming="false"
wrapperClass="org.apache.catalina.core.StandardWrapper">
<Resource name="jdbc/resDB" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/resDB">
<parameter>
<name>validationQuery</name>
<value></value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>pwdpwd</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sybase:Tds:xxxxxxxx:4444</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>uuuu</value>
</parameter>
</ResourceParams>
</Context>
--------------------------------------------------------------
