Subject | Setting up Firebird Pool inside Tomcat 5.5 |
---|---|
Author | Federico Tello Gentile |
Post date | 2005-09-13T14:00:14Z |
I have Tomcat 5.5.7 installed.
Firebird SS 1.5.2
Jaybird 1.5.5
Windows XP Professional SP 2
I read these two pages
http://jaybirdwiki.firebirdsql.org/config/TomcatConnectionPooling
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
I added firebirdsql-full.jar to the webapp's lib directory.
I get this error
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'"
The same error if I copy the firebirdsql-full.jar to the
tomcat/common/lib directory.
Here's how I access the pool
<sql:query var="rs" dataSource="jdbc/TestDB">
select id, nombre, telefono from persona
</sql:query>
<h2>Results</h2>
<c:forEach var="row" items="${rs.rows}">
Id ${row.id}<br/>
Nombre ${row.nombre}<br/>
Tel: ${row.telefono}<br/>
</c:forEach>
Thanks for any help.
---------------------------------
context.xml
---------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/PooledWebapp" debug="5" reloadable="true"
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="dbTest." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/dbTest" auth="Container"
type="org.firebirdsql.pool.FBWrappingDataSource"/>
<ResourceParams name="jdbc/dbTest">
<parameter>
<name>factory</name>
<value>org.firebirdsql.pool.FBWrappingDataSource</value>
</parameter>
<parameter>
<name>userName</name>
<value>SYSDBA</value>
</parameter>
<parameter>
<name>password</name>
<value>masterkey</value>
</parameter>
<parameter>
<name>database</name>
<value>localhost/3050:c:/fede/test.fdb?lc_ctype=UNICODE_FSS</value>
</parameter>
<parameter>
<name>maxConnections</name>
<value>10</value>
</parameter>
<parameter>
<name>minConnections</name>
<value>3</value>
</parameter>
</ResourceParams>
</Context>
-----------------
web.xml
-----------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
Firebird SS 1.5.2
Jaybird 1.5.5
Windows XP Professional SP 2
I read these two pages
http://jaybirdwiki.firebirdsql.org/config/TomcatConnectionPooling
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
I added firebirdsql-full.jar to the webapp's lib directory.
I get this error
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'"
The same error if I copy the firebirdsql-full.jar to the
tomcat/common/lib directory.
Here's how I access the pool
<sql:query var="rs" dataSource="jdbc/TestDB">
select id, nombre, telefono from persona
</sql:query>
<h2>Results</h2>
<c:forEach var="row" items="${rs.rows}">
Id ${row.id}<br/>
Nombre ${row.nombre}<br/>
Tel: ${row.telefono}<br/>
</c:forEach>
Thanks for any help.
---------------------------------
context.xml
---------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/PooledWebapp" debug="5" reloadable="true"
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="dbTest." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/dbTest" auth="Container"
type="org.firebirdsql.pool.FBWrappingDataSource"/>
<ResourceParams name="jdbc/dbTest">
<parameter>
<name>factory</name>
<value>org.firebirdsql.pool.FBWrappingDataSource</value>
</parameter>
<parameter>
<name>userName</name>
<value>SYSDBA</value>
</parameter>
<parameter>
<name>password</name>
<value>masterkey</value>
</parameter>
<parameter>
<name>database</name>
<value>localhost/3050:c:/fede/test.fdb?lc_ctype=UNICODE_FSS</value>
</parameter>
<parameter>
<name>maxConnections</name>
<value>10</value>
</parameter>
<parameter>
<name>minConnections</name>
<value>3</value>
</parameter>
</ResourceParams>
</Context>
-----------------
web.xml
-----------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>