Could any one give me a hand on this one ?
Patrick Reyes
----- Forwarded by Patrick Reyes/CDS/CG/CAPITAL on 10/27/2003 08:22 AM
-----
Patrick Reyes
To: "OJB Users List" <[EMAIL
PROTECTED]>
10/23/2003 07:57 cc: "OJB Users List" <[EMAIL
PROTECTED]>
AM Subject: Re: AW: Character set mismatch
error in Oracle(Document link: Patrick Reyes)
Yep, sorry I forgot to include this information here it is:
<descriptor-repository version="1.0" isolation-level="read-uncommitted">
<jdbc-connection-descriptor
jcd-alias=""
default-connection="true"
platform="Oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle:thin"
dbalias="@gvo2appd12:1521:EFAX817"
username="***"
password="***"
batch-mode="false"
>
<connection-pool maxActive="21" validationQuery="" />
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="1"/>
</sequence-manager>
</jdbc-connection-descriptor>
- with which character set did you create your database
The database was created by our DBA, but he is out for the week :-( How do
I check this ?
- how does the CREATE TABLE statement look like (esp. the datatype in the
database)
CREATE TABLE EFAX.MESSAGE
(ID INTEGER NOT NULL,
CONTENT NVARCHAR2(1) NOT NULL,
STATUS INTEGER NOT NULL,
CREATION_DATE DATE NOT NULL,
MODIFICATION_DATE DATE NOT NULL);
- (well, and maybe the p6spy output of the actual statement sent to the
database=
If only I knew how to use p6spy I would ? Where can I find doc on this tool
?
Thanks and regards,
Patrick Reyes
"Geigl
Maximilian, R235" To: "OJB Users List" <[EMAIL
PROTECTED]>
<Geigl.Maximilian cc: (bcc: Patrick
Reyes/CDS/CG/CAPITAL)
@akdb.de> Subject: AW: Character set mismatch
error in Oracle
10/22/2003 05:53
PM
Please respond to
"OJB Users List"
Hi,
can you tell, which
- jdbc driver you use (THIN or the one that uses Oracle Net) - maybe the
connection
descriptor wourd be helpful
- with which character set did you create your database
- how does the CREATE TABLE statement look like (esp. the datatype in the
database)
- (well, and maybe the p6spy output of the actual statement sent to the
database=
Max
> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 22. Oktober 2003 15:38
> An: [EMAIL PROTECTED]
> Betreff: Character set mismatch error in Oracle
>
>
>
>
>
>
> 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.JavaDate2SqlDat
> eFieldConversion"
>
> />
> <field-descriptor id="4"
> name="modification_date"
> column="MODIFICATION_DATE"
> jdbc-type="DATE"
> conversion =
> "org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDat
> eFieldConversion"
>
> />
>
> </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(OracleState
> ment.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem
> ent.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleSt
> atement.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedStatement.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(OracleState
> ment.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem
> ent.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleSt
> atement.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedStatement.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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
