Thanks for help!

I try several times but it won´t work...
I receive the smae message...

[]´s
Davi


--- In Firebird-Java@yahoogroups.com, Luca Lafranchi
<luca.lafranchi@r...> wrote:

> Hi :)
>
> Try with firebirdsql-full.jar
>
> Ciao
> Luca
> d_rampazo wrote:
>
> > Hi,
> > =20
> > I can=B4t make TOMCAT (version 4.1.24) see the firebirdsql.jar. I=B4m
> > using the connection pooling, but in all cases it talks:
> > " org.apache.commons.dbcp.BasicDataSource@56b93a Cannot load JDBC
> > driver class 'null' "
> > What I=B4m doing wrong?
> > =20
> > firebirdsql.jar is in these folders:
> > Tomcat/common/lib
> > Tomcat/server/lib
> > Tomcat/webapps/teste/WEB_INF/lib
> > =20
> > How it can=B4t load ?
> > =20
> > My Server.xml:
> > =20
> > <?xml version=3D'1.0' encoding=3D'utf-8'?>
> > <Server className=3D"org.apache.catalina.core.StandardServer"

debug=3D"0"

> > port=3D"8005" shutdown=3D"SHUTDOWN">
> > <Listener
> > className=3D"org.apache.catalina.mbeans.ServerLifecycleListener"
> > debug=3D"0" jsr77Names=3D"false"/>
> > <Listener
> >

className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"

> > debug=3D"0"/>
> > <GlobalNamingResources>
> > <Environment name=3D"simpleValue" override=3D"true"
> > type=3D"java.lang.Integer" value=3D"30"/>
> > <Resource auth=3D"Container" description=3D"User database that

can be

> > updated and saved" name=3D"UserDatabase" scope=3D"Shareable"
> > type=3D"org.apache.catalina.UserDatabase"/>
> > <Resource auth=3D"Container" name=3D"jdbc/DBFirebird"
> > scope=3D"Shareable" type=3D"javax.sql.DataSource"/>
> > <ResourceParams name=3D"UserDatabase">
> > <parameter>
> > <name>factory</name>
> >

<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>

> > </parameter>
> > <parameter>
> > <name>pathname</name>
> > <value>conf/tomcat-users.xml</value>
> > </parameter>
> > </ResourceParams>
> > <ResourceParams name=3D"jdbc/DBFirebird">
> > <parameter>
> > <name>factory</name>
> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> > =20=20=20=20=20=20=20
> > <value>jdbc:firebirdsql:192.168.1.157/3050:f:\\db\\company.ib</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>masterkey</value>
> > </parameter>
> > <parameter>
> > <name>maxActive</name>
> > <value>4</value>
> > </parameter>
> > <parameter>
> > <name>maxWait</name>
> > <value>5000</value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.firebirdsql.jdbc.FBDriver</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>SYSDBA</value>
> > </parameter>
> > <parameter>
> > <name>maxIdle</name>
> > <value>2</value>
> > </parameter>
> > </ResourceParams>
> > </GlobalNamingResources>
> > <Service className=3D"org.apache.catalina.core.StandardService"
> > debug=3D"5" name=3D"Tomcat-Standalone">
> > <Connector className=3D"org.apache.coyote.tomcat4.CoyoteConnector"
> > acceptCount=3D"100" bufferSize=3D"2048" compression=3D"off"
> > connectionLinger=3D"-1" connectionTimeout=3D"20000" debug=3D"0"
> > disableUploadTimeout=3D"true" enableLookups=3D"true"
> > maxKeepAliveRequests=3D"100" maxProcessors=3D"75" minProcessors=3D"5"
> > port=3D"8080"
> > protocolHandlerClassName=3D"org.apache.coyote.http11.Http11Protocol"
> > proxyPort=3D"0" redirectPort=3D"8443" scheme=3D"http" secure=3D"false"
> > tcpNoDelay=3D"true" useURIValidationHack=3D"false">
> > <Factory
> > className=3D"org.apache.catalina.net.DefaultServerSocketFactory"/>
> > </Connector>
> > <Connector className=3D"org.apache.coyote.tomcat4.CoyoteConnector"
> > acceptCount=3D"10" bufferSize=3D"2048" compression=3D"off"
> > connectionLinger=3D"-1" connectionTimeout=3D"0" debug=3D"0"
> > disableUploadTimeout=3D"false" enableLookups=3D"true"
> > maxKeepAliveRequests=3D"100" maxProcessors=3D"75" minProcessors=3D"5"
> > port=3D"8009"
> > protocolHandlerClassName=3D"org.apache.jk.server.JkCoyoteHandler"
> > proxyPort=3D"0" redirectPort=3D"8443" scheme=3D"http" secure=3D"false"
> > tcpNoDelay=3D"true" useURIValidationHack=3D"false">
> > <Factory
> > className=3D"org.apache.catalina.net.DefaultServerSocketFactory"/>
> > </Connector>
> > <Engine className=3D"org.apache.catalina.core.StandardEngine"
> > debug=3D"5" defaultHost=3D"localhost"
> > mapperClass=3D"org.apache.catalina.core.StandardEngineMapper"
> > name=3D"Standalone">
> > <DefaultContext
> > className=3D"org.apache.catalina.core.StandardDefaultContext"
> > cookies=3D"true" crossContext=3D"true" name=3D"defaultContext"
> > reloadable=3D"false" swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > </DefaultContext>
> > <Host className=3D"org.apache.catalina.core.StandardHost"
> > appBase=3D"/teste" autoDeploy=3D"true"
> > configClass=3D"org.apache.catalina.startup.ContextConfig"
> > contextClass=3D"org.apache.catalina.core.StandardContext" debug=3D"5"
> > deployXML=3D"true"
> > errorReportValveClass=3D"org.apache.catalina.valves.ErrorReportValve"
> > liveDeploy=3D"true"
> > mapperClass=3D"org.apache.catalina.core.StandardHostMapper"
> > name=3D"localhost2" unpackWARs=3D"true">
> > </Host>
> > <Host className=3D"org.apache.catalina.core.StandardHost"
> > appBase=3D"webapps" autoDeploy=3D"true"
> > configClass=3D"org.apache.catalina.startup.ContextConfig"
> > contextClass=3D"org.apache.catalina.core.StandardContext" debug=3D"0"
> > deployXML=3D"true"
> > errorReportValveClass=3D"org.apache.catalina.valves.ErrorReportValve"
> > liveDeploy=3D"true"
> > mapperClass=3D"org.apache.catalina.core.StandardHostMapper"
> > name=3D"localhost" unpackWARs=3D"true">
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Tomcat

> > Manager Application" docBase=3D"../server/webapps/manager"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/manager" privileged=3D"true" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > <ResourceLink global=3D"UserDatabase" name=3D"users"
> > type=3D"org.apache.catalina.UserDatabase"/>
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"
> > docBase=3D"D:/Java/TomCat/bin/../webapps/myweb"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/myweb" privileged=3D"false" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > <ResourceLink global=3D"jdbc/DBFirebird"
> > name=3D"jdbc/DBFirebird" type=3D"javax.sql.DataSource"/>
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0" docBase=3D"/teste"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"D:\Java\TomCat\webapps\teste" privileged=3D"false"
> > reloadable=3D"true" swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > <Resource name=3D"testeDB" scope=3D"Shareable"
> > type=3D"javax.sql.DataSource"/>
> > <ResourceParams name=3D"testeDB">
> > <parameter>
> > <name>url</name>
> > =20=20=20=20=20=20=20=20=20=20=20=20=20
> > <value>jdbc:firebirdsql:192.168.1.157:f:\\db\\company.ib</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>masterkey</value>
> > </parameter>
> > <parameter>
> > <name>maxActive</name>
> > <value>4</value>
> > </parameter>
> > <parameter>
> > <name>maxWait</name>
> > <value>5000</value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.firebirdsql.jdbc.FBDriver</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>SYSDBA</value>
> > </parameter>
> > <parameter>
> > <name>maxIdle</name>
> > <value>2</value>
> > </parameter>
> > </ResourceParams>
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Tomcat

> > Examples" docBase=3D"examples"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/examples" privileged=3D"false" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > <Logger className=3D"org.apache.catalina.logger.FileLogger"
> > debug=3D"0" directory=3D"logs" prefix=3D"localhost_examples_log."
> > suffix=3D".txt" timestamp=3D"true" verbosity=3D"1"/>
> > <Parameter name=3D"context.param.name" override=3D"false"
> > value=3D"context.param.value"/>
> > <Ejb description=3D"Example EJB Reference"
> > home=3D"com.mycompany.mypackage.AccountHome" name=3D"ejb/Account"
> > remote=3D"com.mycompany.mypackage.Account" type=3D"Entity"/>
> > <Ejb home=3D"com.wombat.empl.EmployeeRecordHome"
> > name=3D"ejb/EmplRecord" remote=3D"com.wombat.empl.EmployeeRecord"
> > type=3D"Entity"/>
> > <Environment name=3D"maxExemptions" override=3D"true"
> > type=3D"java.lang.Integer" value=3D"15"/>
> > <Environment name=3D"foo/name1" override=3D"true"
> > type=3D"java.lang.String" value=3D"value1"/>
> > <Environment name=3D"minExemptions" override=3D"true"
> > type=3D"java.lang.Integer" value=3D"1"/>
> > <Environment name=3D"name3" override=3D"true"
> > type=3D"java.lang.Integer" value=3D"1"/>
> > <Environment name=3D"foo/bar/name2" override=3D"true"
> > type=3D"java.lang.Boolean" value=3D"true"/>
> > <Environment name=3D"foo/name4" override=3D"true"
> > type=3D"java.lang.Integer" value=3D"10"/>
> > <LocalEjb description=3D"Example Local EJB Reference"
> > home=3D"com.mycompany.mypackage.ProcessOrderHome"
> > local=3D"com.mycompany.mypackage.ProcessOrder"

name=3D"ejb/ProcessOrder"

> > type=3D"Session"/>
> > <Resource auth=3D"Container" name=3D"mail/Session"
> > scope=3D"Shareable" type=3D"javax.mail.Session"/>
> > <Resource auth=3D"SERVLET" name=3D"jdbc/EmployeeAppDb"
> > scope=3D"Shareable" type=3D"javax.sql.DataSource"/>
> > <ResourceParams name=3D"mail/Session">
> > <parameter>
> > <name>mail.smtp.host</name>
> > <value>localhost</value>
> > </parameter>
> > </ResourceParams>
> > <ResourceParams name=3D"jdbc/EmployeeAppDb">
> > <parameter>
> > <name>url</name>
> > <value>jdbc:HypersonicSQL:database</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value></value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.hsql.jdbcDriver</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>sa</value>
> > </parameter>
> > </ResourceParams>
> > <ResourceLink global=3D"simpleValue"
> > name=3D"linkToGlobalResource" type=3D"java.lang.Integer"/>
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Tomcat

> > Documentation" docBase=3D"D:\Java\TomCat\webapps\tomcat-docs"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/tomcat-docs" privileged=3D"false" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"
> > docBase=3D"D:\Java\TomCat\webapps\teste"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/teste" privileged=3D"false" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Webdav

> > Content Management" docBase=3D"D:\Java\TomCat\webapps\webdav"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/webdav" privileged=3D"false" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Welcome t=

> > o
> > Tomcat" docBase=3D"D:\Java\TomCat\webapps\ROOT"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"

path=3D""

> > privileged=3D"false" reloadable=3D"false" swallowOutput=3D"false"
> > useNaming=3D"true"

wrapperClass=3D"org.apache.catalina.core.StandardWrapper=

> > ">
> > </Context>
> > <Context

className=3D"org.apache.catalina.core.StandardContext"

> > cachingAllowed=3D"true"
> > charsetMapperClass=3D"org.apache.catalina.util.CharsetMapper"
> > cookies=3D"true" crossContext=3D"true" debug=3D"0"

displayName=3D"Tomcat

> > Administration Application" docBase=3D"../server/webapps/admin"
> > mapperClass=3D"org.apache.catalina.core.StandardContextMapper"
> > path=3D"/admin" privileged=3D"true" reloadable=3D"false"
> > swallowOutput=3D"false" useNaming=3D"true"
> > wrapperClass=3D"org.apache.catalina.core.StandardWrapper">
> > <Logger className=3D"org.apache.catalina.logger.FileLogger"
> > debug=3D"0" directory=3D"logs" prefix=3D"localhost_admin_log."

suffix=3D".t=

> > xt"
> > timestamp=3D"true" verbosity=3D"1"/>
> > </Context>
> > <Logger className=3D"org.apache.catalina.logger.FileLogger"
> > debug=3D"0" directory=3D"logs" prefix=3D"localhost_log."

suffix=3D".txt"

> > timestamp=3D"true" verbosity=3D"1"/>
> > </Host>
> > <Logger className=3D"org.apache.catalina.logger.FileLogger"
> > debug=3D"9" directory=3D"logs" prefix=3D"catalina_log."

suffix=3D".txt"

> > timestamp=3D"true" verbosity=3D"1"/>
> > <Realm className=3D"org.apache.catalina.realm.UserDatabaseRealm"
> > debug=3D"0" resourceName=3D"UserDatabase" validate=3D"true"/>
> > </Engine>
> > </Service>
> > </Server>
> > =20
> > =20
> > Web.xml
> > =20
> > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> > <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
> > Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
> > <web-app>
> > <welcome-file-list>
> > <welcome-file>indexx.jsp</welcome-file>
> > </welcome-file-list>
> > <error-page>
> > <error-code>404</error-code>
> > <location>/error.jsp</location>
> > </error-page>
> > <resource-ref>
> > <res-ref-name>testeDB</res-ref-name>
> > <res-type>javax.sql.DataSource</res-type>
> > <res-auth>Container</res-auth>
> > </resource-ref>
> > </web-app>
> > =20
> > =20
> > Index.jsp
> > =20
> > <html>
> > <head>
> > <meta http-equiv=3D"Content-Type" content=3D"text/html;

charset=3Diso-8859-=

> > 1">
> > <title>DB Test</title>
> > </head>
> > <body>
> > <%@ page import=3D"javax.naming.*" %>
> > <%@ page import=3D"javax.sql.*" %>
> > <%@ page import=3D"java.sql.*" %>
> >
> >
> > <% try{ %>
> > try !!! <br>
> >
> > <% Context ctx =3D new InitialContext(); %>
> > Context !!! <BR>
> > <%
> > if(ctx =3D=3D null )=20
> > throw new Exception("Boom - No Context");
> > %>
> > CTX not null <br>=20
> > <%
> > DataSource ds =3D (DataSource)ctx.lookup("java:comp/env/testeDB");=20
> > %>
> > Data Source<br>
> > <%=20
> >
> > if (ds !=3D null) {
> > Connection conn =3D ds.getConnection();%>
> >
> > Conected!!<br>
> >
> > <% if(conn !=3D null) { %>
> >
> > Works <br>
> >
> > <% } else { %>
> > No....<br>
> > <%=20
> > }
> > conn.close();
> > }
> > }catch(Exception e) { %>
> > <%=3De.getMessage()%>=20
> > <% e.printStackTrace();
> > }
> >
> >
> >
> > %>
> >
> > </body>
> > </html>
> >
> > =20
> > []=B4s
> > Davi Rampazo
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> > =20
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/=20

> >
> >