Dear all,
Check my repository.xml file, is it valid for oracle Impl.
<jdbc-connection-descriptor
platform="Oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="oci8:@(description=(address=(host=dhamu)(protocol=tcp)(port=1521))(connect_data=(sid=tsmc)))"
username="dhamu"
password="dhamu"/>
But i am facing the following error:
java.sql.SQLException: ORA-01036: illegal variable name/number
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at
oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java) at
oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java) at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)[org.apache.ojb.broker.accesslayer.JdbcAccess]
ERROR: SQLException during the execution of the query: ORA-01036: illegal variable
name/number
ORA-01036: illegal variable name/number
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Source) at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at
Test.main(Test.java:32)org.apache.ojb.broker.PersistenceBrokerSQLException[ODMG]
ERROR: null at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown
Source) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at
Test.main(Test.java:32)org.odmg.QueryException at
org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at Test.main(Test.java:32)
Thanks in advance
Dhamu
---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.
