Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2 DataSource for Struts

 
Laura Lee
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65118
89
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the Struts forum.
 
John Ackerman
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic