aspose file tools*
The moose likes Struts and the fly likes Struts datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts datasource" Watch "Struts datasource" New topic
Author

Struts datasource

Prashanth Chandra
Ranch Hand

Joined: Dec 07, 2005
Posts: 79
I have been trying to connect to Struts datasource. Please help me in this as i have been getting this error.

SEVERE: Initializing application data source org.apache.struts.action.DATA_SOURCE
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc ostgresql://localhost/databasename.

This is my struts-config.xml datasource configuation
<data-sources>

<data-source type="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
<set-property property="autoCommit" value="false"/>
<set-property property="description" value="TTM Data Source Configuration"/>
<set-property property="driverClass" value="org.postgresql.Driver"/>
<set-property property="maxCount" value="4"/>
<set-property property="minCount" value="2"/>
<set-property property="password" value="infinity"/>
<set-property property="url" value="jdbc ostgresql://localhost/databasename"/>
<set-property property="user" value="infinity"/>
</data-source>
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

it seems that you have no suitable driver for your connection string. so check to see whether you have postgresql.js (postgresql jdbc driver) in your web-inf/lib folder or not.


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Prashanth Chandra
Ranch Hand

Joined: Dec 07, 2005
Posts: 79
Hi
Thanks for the reply. I have included pg74.215.jdbc3.jar and jdbc.jar files in the class path. I have also included these jar files in my application in the WEB-INF/lib. But still the same error occurs.

The error is
SEVERE: Initializing application data source org.apache.struts.action.DATA_SOURCE
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc ostgresql://localhost/databasename'
Rob Morning
Greenhorn

Joined: Jan 02, 2006
Posts: 4
If you are using Commons dbcp then the correct <set-property> sub elements
are :

<set-property property="driverClassName" value="org.postgresql.Driver"/> NOT
"driverClass"
<set-property property="username" value="infinity"/> NOT "user"

Try that and I think you should be okay .. If your using other DataSources then you need to check the appropriate documentation to determine the available property data ..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Struts datasource