Hi
I am using Oracle thin driver
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="OracleDS"
location="jdbc/AstraDB"
xa-location="jdbc/xa/OracleXADS"
ejb-location="jdbc/AstraDB"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="ASTRA2"
password="ASTRA2"
url="jdbc:oracle:thin:@127.0.0.1:1521:ASTRA"
inactivity-timeout="30"
/>
The query runs normally for all other prepared statement.but in a
particular case it does not.
I needed to know if there is a problem in the implementation of
PreparedStatement in Oracle Driver because of which it does not run.
The same query as a statement does run.
For debugging of the query i used the debuggableStatement from
www.javaworld.com (this lets me print the Preparedsatement as
psm.toString())
String sql="Select .......";
com.javaunderground.jdbc.StatementFactory.setDefaultDebug(com.javaunderg
round.jdbc.DebugLevel.VERBOSE);
com.javaunderground.jdbc.StatementFactory.setDefaultFormatter(new
com.javaunderground.jdbc.OracleSqlFormatter());
PrepareStatement
psm=com.javaunderground.jdbc.StatementFactory.getStatement(connection,sq
l);
psm.setString(...);
.........
Resultset rs=psm.exQuery();
//THe Resultset is empty
now if i do
PrepareStatement psm1=connection.PrepareStatement(psm.toString());
rs=psm.exQuery();
//rs has tuples!!!
Can anyone help me on this one??
Regards
Alan
==========================================================================To
unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
