This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Struts and the fly likes DB2 DataSource for Struts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "DB2 DataSource for Struts" Watch "DB2 DataSource for Struts" New topic
Author

DB2 DataSource for Struts

Laura Lee
Greenhorn

Joined: Jan 23, 2005
Posts: 2
Dear All,
I am using WSAD to implement a Struts web app, with DB2 as database.
I am not sure what <data-source>'s type and driverClassName I should define/use for DB2 connection within struts-config.xml file.

Your tips is greatly appreciated,

laura
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60752
    
  65

Moving to the Struts forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
John Ackerman
Greenhorn

Joined: Jun 04, 2004
Posts: 9
Laura,

I am new to Struts but the commented settings below will work on an iSeries. The AS400JDBCDriver should work from anywhere while the DB2Driver only works if you are running on the iSeries.

John

<data-sources>
<data-source>
<set-property property ="driverClass"
value = "com.mysql.jdbc.Driver" />
<!-- value = "com.ibm.as400.access.AS400JDBCDriver" /> -->
<!-- value = "com.ibm.db2.jdbc.app.DB2Driver" /> -->
<set-property property ="url"
value = "jdbc:mysql://localhost/ccllc"/>
<!-- value = "jdbc:as400://192.168.1.254"/> -->
<!-- value = "jdbc:db2:*local"/> -->
[ January 26, 2005: Message edited by: John Ackerman ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 DataSource for Struts
 
Similar Threads
DB2 DataSource for Struts
Collations
Websphere and JDBC.
trim on where clause
setting utf-8 in jsp