help! Connection pointbase error

i used webserver7.0.

this is my server.xml:

<jdbc-resource>

<jndi-name>jdbc/sample</jndi-name>

<datasource-class>com.pointbase.jdbc.jdbcUniversalDriver</datasource-c lass>

<property>

<name>password</name>

<value>PBPUBLIC</value>

</property>

<property>

<name>datasourceName</name>

<value>sample</value>

</property>

<property>

<name>user</name>

<value>PBPUBLIC</value>

</property>

<property>

<name>networkProtocol</name>

<value>pointbase</value>

</property>

<property>

<name>databaseName</name>

<value>sample</value>

</property>

<property>

<name>serverName</name>

<value>localhost</value>

</property>

<property>

<name>port</name>

<value>9092</value>

</property>

<description/>

</jdbc-resource>

<class-path-suffix>C:/Sun/JavaES5/WebServer7/lib/mysql-connector-java-3.1 .14-bin.jar;C:/pointbase56/lib\pbclient56ev.jar</class-path-suffix>

my sun-web.xml is

<resource-ref>

<res-ref-name>jdbc/jdbc-simple</res-ref-name>

<jndi-name>jdbc/sample</jndi-name>

</resource-ref>

and web.xml is

web.xml

<resource-ref>

<res-ref-name>jdbc/jdbc-simple</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

<res-sharing-scope>Shareable</res-sharing-scope>

</resource-ref>

my code is :

StringdsName = "java:comp/env/jdbc/jdbc-simple";

DataSource ds = (javax.sql.DataSource) initContext.lookup(dsName);

Connection conn= ds.getConnection();

i got a error:

"com.pointbase.jdbc.jdbcUniversalDriver"

[2146 byte] By [ratgasdfgasdfsaa] at [2007-11-27 9:50:42]
# 1
I think its because of the ';' in class-path-suffix. It should be ':'
scandya at 2007-7-13 0:19:33 > top of Java-index,Web & Directory Servers,Web Servers...
# 2

The DataSource class has to be a class that implements javax.sql.DataSource.

AFAIK com.pointbase.jdbc.jdbcUniversalDriver does not implement that class.

You have to determine which class in your JDBC Driver does by looking at the driver classes. It varies depending on the vendor, database and version of the driver.

Try using "com.pointbase.jdbc.jdbcDataSource"

Docs:

http://docs.sun.com/app/docs/doc/820-1062/6ncoqnpdk?a=view#gaiei

http://docs.sun.com/app/docs/doc/820-1061/6ncopp90c?a=view

nseguraa at 2007-7-13 0:19:33 > top of Java-index,Web & Directory Servers,Web Servers...