Struts database connection how?

feen4u · February 4th, 2004, 01:02 PM

Hello everybody,

How to connect a ms access db or db2 in struts.
i am using the server WSAD 5.1
Struts 1.1

theinscrutable · January 10th, 2005, 01:47 PM

In your file struts-config.xml the data connection for MS Access looks liek this...

Code:

      
      <data-source type="org.apache.commons.dbcp.BasicDataSource">
        <set-property property="key" value="Access_1" />  
        <set-property property="driverClassName" value="sun.jdbc.odbc.JdbcOdbcDriver" />  
        <set-property property="url" value="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ='drive_letter:/full_path/file_name.mdb'" />
        <set-property property="username" value="" /> 
        <set-property property="password" value="" /> 
      </data-source>