Hi
I am trying to retrive Varying array using BEA Weblogic . But gives error as
inconsistent datatypes
Code is as follow
Statement stmt= null;
Connection conn = null;
try
{
Class.forName("weblogic.jdbc.t3.Driver").newInstance();
// Set up properties for connecting to the
DBMS
Properties dbprops = new Properties();
dbprops.put("user",
"mark1");
dbprops.put("password",
"mark1");
dbprops.put("server",
"mark");
Properties t3props = new Properties();
t3props.put("weblogic.t3.dbprops",
dbprops);
// Set the URL of WebLogic to create an
embedded T3Client
t3props.put("weblogic.t3.serverURL","t3://balkrishnap:7001");
t3props.put("weblogic.t3.driverClassName",
"weblogic.jdbc.oci.Driver");
t3props.put("weblogic.t3.driverURL","jdbc:weblogic:oracle");
t3props.put("weblogic.t3.cacheRows","2");
conn =
DriverManager.getConnection("jdbc:weblogic:t3", t3props);
stmt = conn.createStatement();
stmt.execute("select
tsiltenderid,tsildeliverydetails from tenderselleritemlocation");
ResultSet rs = stmt.getResultSet();
while (rs.next()) {
System.out.println(rs.getString("tsiltenderid"));
//System.out.println(rs.getArray("tsildeliverydetails"));
}
ResultSetMetaData rsmd = rs.getMetaData();
stmt.close();
conn.close();
}
catch(Exception ex)
{
try
{
stmt.close();
conn.close();
}
catch(Exception e)
{
}
System.out.println("Exception"+ex.getMessage().toString());
}
Can any body help me out?
Thankx
Balkrishna Parab
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
