Code to connect database with struts using MyEclipse

[Krishna Tota]

Hellow friends,

I am using struts with Myeclipse 6.0

I want the code for connecting to the databse using Datasource object.

Please help me.
I am waiting for replay.

Thank you,
Krishna.

[jagan bisoyi]

Hi Krishna,
use the code inside your strutsconfig.xml
i.e.
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource" key="jdbc/struts">
<set-property property="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<set-property property="url" value="jdbc:sqlserver://localhost:1433;Database=Databasename" />
<set-property property="username" value="xx" />
<set-property property="password" value="xxxxxx" />
<set-property property="validationQuery" value="SELECT * FROM Table name" />
</data-source>
</data-sources>

[Merrill Higginson]

With all respect to Jagan, it is best if you do not use the Struts DataSource. It has been removed in later versions, so you limit your upgrade options by using it.

The best practice for data sources in Struts applications as in all Java EE applications is to use the Application Server's utilities for setting up a data source that is registered in the Java Naming and Directory Interface (JNDI) and then using JNDI to look up the data source in your code. For more information on this, see question 8 of this forum's FAQ.