> 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());
> stmt.setString(1,aLexiconId);
> ResultSet rset = stmt.executeQuery(qry);//this is the line appearing in the bottom
>of the stack trace....
>
> this example uses a string as parameter type but same result with binary stream or
>long values... The string has the good type,
the good length, is correct, so my code works...
> (it works because same code using a connection obtained from direct invokation
>through the Oracle driver works).
> Now, my Oracle Connection is useless in a BMP context (or
> from my servlets for JDBC direct invokations).
I'd really be amazed if this works directly. When using prepared statements you
should use
stmt.executeQuery();
not
stmt.execute(String)
which is only there because it exists in the superclass. If you do the latter you are
effectively using a normal statement.
try executeQuery() and see how you go.
hth
dim
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
