old (6.7.2) TS - tagging failing looking for db driver

Adam Stoller

I've got a customer who hasn't [yet] updated their TeamSite from 6.7.2.0 on Windows 2003 SP2 R2

 

Things were basically working, but they recently went through some server migrations (servers moved to new networks or somesuch) and now, while most things seem to be working, the PLC workflow is having issues during the tagging step - the browser page comes up but is completely blank.

 

In the IWHOME/local/logs/iwui/servletd_out.log I'm seeing the following error:

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL '${production.url}'
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
	... 75 more
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:243)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
	... 78 more

I believe it's looking for information in the ojdbc14.jar - of which there are several on the server (i.e. within ODHOME/userlib, etc.) - but I don't know where the tagging UI is looking for that jar file - or if I'm chasing the proverbial red-herring trying to figure that out.

 

Any idea where I should be looking for the jar file that should contain the driver for the tagging UI to be happy?

 

 

 

Rick Poulin

It's more that your "production.url" property doesn't exist, so it doesn't know what driver type to even look for.

 

Assuming this is the livesite one (based on the property name) then in database.properties, you either need to set db.enabled=false or configure the production.* properties.