gaurav sharma
asked on
Use JNDI to connect to DB
I have a process set up to continuously run sql scripts to the database using the idea from the link below
http://www.theserverlabs.com/blog/2009/05/18/continuous-integration-with-oracle-plsql-utplsql-and-hudson/
How can I replace the JDBC connection with JNDI in the pom.xml
http://www.theserverlabs.com/blog/2009/05/18/continuous-integration-with-oracle-plsql-utplsql-and-hudson/
How can I replace the JDBC connection with JNDI in the pom.xml
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is a sql-maven plugin that connects to the database using the configuration like below.
<build>
<plugins>
<plugin>
<groupId>org.codehaus.mojo
<artifactId>sql-maven-plug
<version>1.5</version>
<dependencies>
<dependency>
<groupId>com.oracle</group
<artifactId>ojdbc5</artifa
<version>11.2.0.1.0</versi
<configuration>
<driver>oracle.jdbc.driver
<url>jdbc:oracle:thin:@ser
<username>testing</usernam
<password>testing</passwor
<delimiter>/</delimiter>
<delimiterType>row</delimi
<keepFormat>true</keepForm
</configuration>
The username and password cannot be put in here when building to personal identification schemas.
Hence a JNDI connection is being created to connect to the DB.
How can I use the JNDI connection in the pom.xml ?