ufs.xml oracle connection string

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

EMvdB
Ebase User
Posts: 4
Joined: Fri Jun 06, 2008 7:33 am

ufs.xml oracle connection string

#1

Postby EMvdB » Wed Jul 09, 2008 7:45 am

The connection string as in the sample of ufs.xml is like this:
Resource name="jdbc/UFSREPOSITORY" auth="Container"
type="javax.sql.DataSource"
username="***" password="***"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@***:1521:***"
maxWait="30000" max="10" maxIdle="5"
factory="com.ebase.jndi.DataSourceFactory"
validationQuery="select 1 from dual" checkLevel="1" preparedStatementCache="0"


But reading a how-to on Apache Tomcat they mentioned the following:
For Oracle 9i onwards you shuld use
oracle.jdbc.OracleDriver
rather than
oracle.jdbc.driver.OracleDriver

What should I do (we are using Oracle 9)? Change the syntax? How to test if it is succesfull?
0 x

User avatar
nftfi
Ebase User
Posts: 26
Joined: Fri Sep 14, 2007 3:18 pm
Location: Wales

#2

Postby nftfi » Thu Jul 10, 2008 1:14 pm

we use oracle 9i as a repository and the driver class name is set to oracle.jdbc.driver.OracleDriver and it works fine.

N
0 x

EMvdB
Ebase User
Posts: 4
Joined: Fri Jun 06, 2008 7:33 am

#3

Postby EMvdB » Thu Jul 10, 2008 2:05 pm

We are using the same driver class name, but on this site http://tomcat.apache.org/tomcat-5.5-doc ... howto.html they mention the following:
For Oracle 9i onwards you should use oracle.jdbc.OracleDriver rather than oracle.jdbc.driver.OracleDriver as Oracle have stated that oracle.jdbc.driver.OracleDriver is deprecated and support for this driver class will be discontinued in the next major release.

That's why I would like to know what is better to do at the moment.
0 x


Who is online

Users browsing this forum: No registered users and 123 guests