> "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 then I was able to use 2 PreparedStatements because of a bug
in the previous release where the PreparedStatement was created ignoring init
parameters...
Nice stuff but a PreparedStatement without binding facility who cares ?
> We can't read your mind or access your computer.
>
Surprising for gurus ?
I guess but all data is already on the dedicated forum...
Jboss 2.4.4 - patched (jbossspool.jar to get PreparedStatements with correct types).
Oracle 8.1.7.3 using the oracle driver
this is the stack trace:
what is the main difference with a direct call to the Oracle driver:
java.sql.SQLException: ORA-01008: not all variables bound
[12:22:05,536,Default] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
[12:22:05,537,Default]
[12:22:05,537,Default] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[12:22:05,538,Default]
[12:22:05,538,Default] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
[12:22:05,539,Default]
[12:22:05,539,Default] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
[12:22:05,540,Default]
[12:22:05,540,Default] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
[12:22:05,541,Default]
[12:22:05,541,Default] at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
[12:22:05,542,Default]
[12:22:05,542,Default] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
[12:22:05,543,Default]
[12:22:05,543,Default] at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
[12:22:05,544,Default]
[12:22:05,544,Default] at
com.viveo.lmt.server.web.servlets.shared.MergedLexicon.init(MergedLexicon.java:62)
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).
Jerome
_________________________________________________________
View thread online: http://main.jboss.org/thread.jsp?forum=66&thread=8519
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
