<context path= "/test" docbase= "E:/workdir/workspace/testweb" debug= "5" reloadable= "true" crosscontext= "true" >
<resource name= "Jdbc/oracledb" auth= "Container" type= "Javax.sql.DataSource"/>
<resourceparams name= "Jdbc/oracledb" >
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>500</value>
</parameter>
<parameter>
<name>username</name>
<value>inet_pm</value>
</parameter>
<parameter>
<name>password</name>
<value>inet_pm</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
<!--<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>-->
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin: @localhost:1521:unms</value>
<!--<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=KB_Rate</value>-->
</parameter>
</ResourceParams>
</Context>
Code test:
Context Ctx=new InitialContext ();
DataSource ds = (DataSource) ctx.lookup ("Java:comp/env/jdbc/oracledb");
Connection conn=ds.getconnection ();
Dmsg.info ("# # #have got a Connection:" +conn);
SimpleDateFormat format1 = new SimpleDateFormat (FORMATPATTERNDB);
SimpleDateFormat format2 = new SimpleDateFormat (Formatpattern);
String sql= "SELECT * from Wgsmr_pm_file";
PreparedStatement ps=conn.preparestatement (SQL);
ResultSet Rs=ps.executequery ();
Dmsg.info ("# # #task-" +id+ "have executed a DB operation");
ResultSetMetaData RSMD = Ps.getmetadata ();
int clmncount = Rsmd.getcolumncount ();
string[] DataType = new String[clmncount];
String[] Clmnname=new String[clmncount];
for (int i = 0; i < Clmncount; i++)
// {
Datatype[i] = rsmd.getcolumntypename (i + 1);
Clmnname[i]=rsmd.getcolumnname (i+1);
// }
while (Rs.next ()) {
StringBuffer rcd=new StringBuffer ();
for (int i = 0; i < Clmncount; i++)
// {
if (Datatype[i].equals ("VARCHAR2"))
// {
Rcd.append (rs.getstring (i + 1));
Continue
// }
if (Datatype[i].equals ("DATE"))
// {
String dd = rs.getstring (i + 1);
Rcd.append (Dd/*format2.format (Format2.parse (DD)) * *);
Try
//// {
Rcd.append (Dd/*format2.format (Format2.parse (DD)) * *);
//// }
catch (ParseException e)
//// {
Dmsg.error (e);
Break
//// }
Continue
// }
Rcd.append (rs.getstring (i + 1));
// }
Dmsg.info (RCD);
// }
Rs.close ();
Ps.close ();
Conn.close ();