Ahoj,
ja pouzivam driverClassName=org.postgresql.Driver a
url=jdbc:postgresql://10.0.0.10:1402/dev
Prislusne jarko s driverem je ke stazeni na
http://jdbc.postgresql.org/download.html a umisteno do
${catalina.home}/common/lib
JF
Quoting Palenik Zoltan <[EMAIL PROTECTED]>:
Dobry den,
chcem migrovat nasu aplikaciu z websphere na tomcat 5.5 + eclipse ( databaza
je progress).
Po vytvoreni web.xml :
<?xml version="1.0" encoding="UTF-8"?>
<web-app version=" 2.4" 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">
<servlet>
<servlet-name>Startup</servlet-name>
<servlet-class>com.abc.servlet.Startup</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Startup</servlet-name>
<url-pattern>/Startup</url-pattern>
</servlet-mapping>
<resource-ref>
<res-ref-name>jdbc/baza1</res-ref-name>
<res-type> javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref >
<res-ref-name>jdbc/baza2</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<web-app>
a do defaultneho server.xml co ponukne Eclipse, ked chem aplikaciu pustat
pod tomcat-om
som doplnil do casti </GlobalNamingResources> :
<Resource name="jdbc/baza1" auth="Container" scope="Shareable"
type="javax.sql.DataSource" maxActive="100" maxIdle="30"
maxWait="10000" username="cust" password="cust"
driverClassName="com.progress.sql.jdbcx.datasource.JdbcProgressDataSource"
url="jdbc:jdbcprogress:T: 10.0.0.10:1428:dev" />
<Resource name="jdbc/baza2" auth="Container" scope="Shareable"
type=" javax.sql.DataSource" maxActive="100" maxIdle="30"
maxWait="10000" username="cust" password="cust"
driverClassName="com.progress.sql.jdbcx.datasource.JdbcProgressDataSource "
url="jdbc:jdbcprogress:T:10.0.0.10:1402:dev" />
podla
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
po spusteni dostanem hlasku:
Cannot create JDBC driver of class '' for connect URL 'null'
java.sql.SQLException : No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource
.java:773)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
(BasicDataSource.java:540)
Skusal som uz aj na Tomcate 5.0 ta ista hlaska.
Dakujem za pomoc,
z.