Hi,
I am using Turbine with (Torque) peer and facing some problem. Please answer
to folowing query.
I am having Oracle 8i database and wanna insert/retrieve java objects.
Issues:
1) In peer classes data type for blob is byte[]
2) While inserting java object for example:
------------------------------------------------
package org.apache.turbine;
public class BlobTestObject implements java.io.Serializable{
int i=99;
}
-----------------------------------------------
I am getting following exception:
Exception in thread "main" java.sql.SQLException: ORA-01465: invalid hex
number
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement
.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java)
at com.workingdogs.village.Record.saveWithInsert(Record.java:328)
at com.workingdogs.village.Record.save(Record.java:185)
at com.workingdogs.village.Record.save(Record.java:166)
at
org.apache.turbine.om.peer.BasePeer.insertOrUpdateRecord(BasePeer.jav
:860)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:764)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
at
rg.apache.turbine.BaseTestBlobPeer.doInsert(BaseTestBlobPeer.java:11
3)
at org.apache.turbine.TestBlob.main(TestBlob.java:52)
My requirement is having multiple BLOB columns in a single oracle tabel.
Please let me know how to insert java objects using torque and peer.
Looking forward to hear from u.
Regards,
Harvinder
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
