I am trying to access an Oracle 8i DB via OJB.
Here is my repository def:
<!-- This repository file is generated by the impart OJB Generator -->
<!-- www.impart.ch [EMAIL PROTECTED] -->
<!-- created at 22 Oct 2003 12:37:29 GMT -->
<!-- Definitions for .EFAX -->
<class-descriptor
class="com.capgroup.mo.transport.Message"
table="EFAX.MESSAGE"
>
<field-descriptor id="0"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="1"
name="content"
column="CONTENT"
jdbc-type="VARCHAR"
/>
<field-descriptor id="2"
name="status"
column="STATUS"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="creation_date"
column="CREATION_DATE"
jdbc-type="DATE"
conversion =
"org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"
/>
<field-descriptor id="4"
name="modification_date"
column="MODIFICATION_DATE"
jdbc-type="DATE"
conversion =
"org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"
/>
</class-descriptor>
And here is my class:
// Generated by impart OJB Generator
// www.impart.ch [EMAIL PROTECTED]
// created at 22 Oct 2003 12:37:30 GMT
package com.capgroup.mo.transport;
import java.util.Date;
//import java.sql.*;
public class Message
{
private Object content;
private Date creation_date;
private long id;
private Date modification_date;
private long status;
public Object getContent()
{
return this.content;
}
public void setContent(Object param)
{
this.content = param;
}
public Date getCreation_date()
{
return this.creation_date;
}
public void setCreation_date(Date param)
{
this.creation_date = param;
}
public long getId()
{
return this.id;
}
public void setId(long param)
{
this.id = param;
}
public Date getModification_date()
{
return this.modification_date;
}
public void setModification_date(Date param)
{
this.modification_date = param;
}
public long getStatus()
{
return this.status;
}
public void setStatus(long param)
{
this.status = param;
}
public String toString(){
return " [CONTENT] " + content + " [CREATION_DATE] " + creation_date +
" [ID] " + id + " [MODIFICATION_DATE] " + modification_date + " [STATUS] "
+ status;
}
/* public IValueObject copy(IValueObject vo){
Message tmp = (Message) vo;
if(vo==null) return this;
setContent(tmp.getContent());
setCreation_date(tmp.getCreation_date());
setId(tmp.getId());
setModification_date(tmp.getModification_date());
setStatus(tmp.getStatus());
return this;
}*/
}
I am getting the following error:
SQL:INSERT INTO EFAX.MESSAGE
(ID,CONTENT,STATUS,CREATION_DATE,MODIFICATION_DATE) VALUES (?,?,?,?,?)
executeInsert: [EMAIL PROTECTED]
SQLException during the execution of the insert (for a
com.capgroup.mo.transport.Message): ORA-12704: character set mismatch
java.sql.SQLException: ORA-12704: character set mismatch
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.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Sourc e)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
com.capgroup.mo.transport.test.TestMessage.main(TestMessage.java:37)
closeResources was called
java.sql.SQLException: ORA-12704: character set mismatch
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.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
com.capgroup.mo.transport.test.TestMessage.main(TestMessage.java:37)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: ORA-12704:
character set mismatch
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
com.capgroup.mo.transport.test.TestMessage.main(TestMessage.java:37)
If someone already had a similar error, I would really appreciate some
help,
Regards,
Patrick Reyes
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
