my dog learned polymorphism
The moose likes Struts and the fly likes DB2 DataSource for Struts Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Reply 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: 56224
    
  13

Moving to the Struts forum.


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About 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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: DB2 DataSource for Struts
 
Similar Threads
DB2 DataSource for Struts
setting utf-8 in jsp
Collations
Websphere and JDBC.
trim on where clause