select is not broken
Ask on the db/persistence forum and give at least a
little to go by, like
jboss version, oracle version, oracle driver, config,
error, trace, etc.
I posted 2 messages with all necessary stuff on the db forum, but I just lost some
time...
I recompiled Jboss source
String qry = SELECT OBJECT_PROPERTY FROM LEXICON_OBJECT_TBL WHERE OBJECT_ID =?;
PreparedStatement stmt = dataSourceConnection.prepareStatement( qry,
ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
System.err.println(Lexicon id size ( PreparedStatement)= + aLexiconId.length());
PreparedStatement stmt = dataSourceConnection.prepareStatement( qry,
ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
System.err.println(Lexicon id size ( PreparedStatement)= + aLexiconId.length());
stmt.setString(1,aLexiconId);
ResultSet rset = stmt.executeQuery(qry);//this is the
Dmitri - I couldn't see this one until you astutely pointed it out.
Cheers
From: Jerome Moliere [EMAIL PROTECTED]
Date: 2002/02/15 Fri AM 04:19:18 EST
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] Problem (Bug?) with Oracle preparedstatement
PreparedStatement stmt
You are not using a prepared statement the way you
are calling the executeQuery(String query) method.
You need to call one which takes no arguments and
operates on the prepared statement. When you pass
in the string after setString() you are effectively
not calling setString().
oops!!!
select is not broken
Ask on the db/persistence forum and give at least a little to go by, like
jboss version, oracle version, oracle driver, config, error, trace, etc.
We can't read your mind or access your computer.
david jencks
On 2002.02.14 11:42:46 -0500 Jerome Moliere wrote:
Hi all
: Thursday, February 14, 2002 11:34 AM
Subject: Re: [JBoss-dev] Problem (Bug?) with Oracle preparedstatement
select is not broken
Ask on the db/persistence forum and give at least a little to go by, like
jboss version, oracle version, oracle driver, config, error, trace, etc.
We can't read