Configuring IdM 7 on Tomcat 5.5 to use a Mysql (5.0.41) datasource

I've been trying, for some time now, to configure Idm 7 to use a mysql datasource using the interface provided by the lh setup coomand.

I'm supply the following values:

DataSource Name/Path: jdbc/wavesetDB

Initial Context Factory: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

I get the following error:

com.waveset.util.ConfigurationError: Failed to load JDBC DataSource 'jdbc/wavesetDB':

==> javax.naming.NoInitialContextException: Cannot instantiate class: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

I know the datasource is working as I've written a servlet that users the datasource to query the database.

The OS is windows and jdk version is 1.4.2.

Any help will be appreciated.

Thanks

[798 byte] By [crouching_kittena] at [2007-11-27 7:01:24]

«« Reading Console input
»» how to get reference of the jFrame object

# 1

....have you copied the mysql connector jar file to your IDM \WEB-INF ?It should work after that...

harrywkla at 2007-7-12 18:52:14 >

top of Java-index,Web & Directory Servers,Directory Servers...

# 2

yep, the file containing the mysql classes is present in the WEB-INF/lib directory.C

crouching_kittena at 2007-7-12 18:52:14 >

# 3

What output do you get for ./lh setRepo -cIs it something like MysqlDataStore:jdbc:mysql://localhost/waveset?Ankush

ankushkapoora at 2007-7-12 18:52:14 >

# 4

Yes, I getMysqlDataStore:jdbc:mysql://localhost/wavesetRegdsCK

crouching_kittena at 2007-7-12 18:52:14 >

# 5

I don't think you've understood what I was trying to accomplish.

My IdM installation was configured to use the mysql jdbc driver. However, I wanted IdM to use a mysql datasource, within Tomcat. The datasource was configured correctly within Tomcat, this was verified by using a servlet that used the datasource to query the database. But the steps I'm missing are the steps similar Appendix C from the Installation Guide.

Hope that cleared things up.

crouching_kittena at 2007-7-12 18:52:14 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Configuring IdM 7 on Tomcat 5.5 to use a Mysql (5.0.41) datasource

Web & Directory Servers Hot Topic

Web & Directory Servers

All Classified