tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jpmad4it <jpill...@fortvale.com>
Subject Re: Help: Connecting Tomcat to CA-IDMS using JDBC Type 4 Drivers (JNDI / IDMSDataSource)
Date Thu, 15 Jan 2009 14:06:17 GMT

I have some more questions:

For my datasource connection paramaters I have the IdmsDataSource class, and
the IdmsConnectionPoolDataSource class.

The IdmsDataSource class is used with an application server provided Java
Naming and Directory Interface (JNDI) naming service to establish a
connection to a CA IDMS database. IdmsDataSource properties are used to
specify the connection parameters. These properties are the equivalent of
the DriverPropertyInfo attributes described in the previous section and can
be used to completely define the parameters needed to connect to a database.
Here are some IdmsDataSource properties:

accountInfo, connectSuspend, databaseName, dataSourceName, externalWait,
networkProtocol, password, portNumber, programName, resourceInterval,
roleName, serverLength, serverName, serverTrace, user etc etc.

Can these simply be placed in the server.xml config under my <resource> as
follows:

<Resource name="jdbc/TestIDMS" auth="Container" type="javax.sql.DataSource"
                   maxActive="100" maxIdle="30" maxWait="1000"
connectSuspend="true" dataSourceName="something" externalWait="20"
networkProtocol="TCP" 
                   username="test" password="test"
driverClassName="ca.idms.jdbc.IdmsJdbcDriver"
                   url="jdbc:idms://IP:3709/DICT" 
		     removeAbandoned="true" removeAbandonedTimeout="300"
logAbandoned="true" />

I went ahead and set these, and upon shutdown and restart Tomcat does not
give any error. However, the instructions say to use the caidms.properties
file (where these properties should be set) and include the location to the
file in the $CLASSPATH. I'm wondering if I can use either of these methods?

The IdmsConnectionPoolDataSource class implements the JDBC
ConnectionPoolDataSource interface. It is used with an application server
that provides container managed connection pooling to establish a pooled
connection to a CA IDMS database.  IdmsConnectionPoolProperties are used by
the application server connection pool manager to administer the pool of
connections for a particular data source. Does Tomcat support this method?
Some properties for this class are:

connectSuspend, initialPoolSize, maxIdleTime, maxPoolSize, propertyCycle
etc.

Can these properties also be added to the <resource> in the server.xml
config (if Tomcat supports this method)?

Any help would be great.
rgds J

-- 
View this message in context: http://www.nabble.com/Help%3A-Connecting-Tomcat-to-CA-IDMS-using-JDBC-Type-4-Drivers-%28JNDI---IDMSDataSource%29-tp21433283p21478261.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message