This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC resourceRef wrong on Tomcat 6

 
Steve Nelligan
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


When I list the environment Object the following is the list of objects I get.

I believe that all of them should be org.apache.tomcat.dbcp.dbcp.BasicDataSource

Each was declared the same except the fsSql uses a Microsoft Driver and jTDS using a jtds driver for MS-SQL.

I added "factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" to the context file, but this did not help.

Any ideas why the SQL connections are being created differently?



Thanks in advance.

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I believe that all of them should be org.apache.tomcat.dbcp.dbcp.BasicDataSource

Why do you believe this? I would guess jTDS doesn't use DBCP.
 
Steve Nelligan
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


I am trying to setup Tomcat to use JNDI for dataConnections.

I have Oracle working, but can not get SQL working. What I was looking for was differences between the Oracle and SQL connections.

I can't figure out why Oracle would work, but not SQL.

This is the error I am getting on the screen when trying to connect to a SQL Server:


Error Log:

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic