Hi
I'm trying to get my JDO example to run... no success so far! The
information given in the examples for Informix is a bit thin...
I created the database "castor" in the server "sri_backup" on the host
"neko.sri.ch".
I tried to configure the database.xml file in the following ways:
*** 1 ***
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version
1.0//EN"
"http://castor.exolab.org/jdo-conf.dtd";>
<database name="test" engine="informix" >
<data-source class-name="com.informix.jdbcx.IfxDataSource">
<params user="informix" password="**********"
port-number="2055" server-name="sri_backup" />
</data-source>
<mapping href="mapping.xml" />
</database>
Here, I'm not sure what the server name actually is... the domain name? Or
the Informix database name? I tried "sri_backup", "castor@sri_backup",
"[EMAIL PROTECTED]" or "neko.sri.ch"...
Anyway, I get:
[test] Begin transaction
[test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM
prod,OUTER prod_detail WHERE prod.id=prod_detail.prod_id AND (prod.id = ?)
[test] java.lang.ClassCastException: java.util.NoSuchElementException
[test] java.lang.ClassCastException: java.util.NoSuchElementException
[test] at
com.informix.jdbcx.IfxDataSource.getSqliConnection(IfxDataSource.java:195)
[test] at
com.informix.jdbcx.IfxDataSource.getConnection(IfxDataSource.java:123)
[test] at
org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(DatabaseRegis
try.java:399)
[test] at
org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Transactio
nContextImpl.java:203)
[test] at
org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:6
44)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:458)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:405)
[test] at jdo.Test.run(Test.java:107)
[test] at jdo.Test.main(Test.java:62)
*** 2 ***
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version
1.0//EN"
"http://castor.exolab.org/jdo-conf.dtd";>
<database name="test" engine="informix" >
<driver class-name="com.informix.jdbc.IfxDriver"
url="jdbc:informix-sqli://neko.sri.ch:2055/castor:INFORMIXSERVER=sri_backup"
>
<param name="user" value="informix" />
<param name="password" value="*********" />
</driver>
<mapping href="mapping.xml" />
</database>
Then I get:
[test] Begin transaction
[test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM
prod,OUTER prod_detail WHERE prod.id=prod_detail.prod_id AND (prod.id = ?)
[test] org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: Transactions not supported
[test] java.sql.SQLException: Transactions not supported
[test] at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:340)
[test] at
com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1079)
[test] at
org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Transactio
nContextImpl.java:205)
[test] at
org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:6
44)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:458)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:405)
[test] at jdo.Test.run(Test.java:107)
[test] at jdo.Test.main(Test.java:62)
Well... could anyone help me? Also, it would be helpful if (once we get this
thing running) an example for Informix could be included in the
documentation.
Thanks & regards,
Eric
_______________________________________
swissinfo Swiss Radio International
Eric Lewis
IT Engineering
Giacomettistrasse 1
CH-3000 Berne 15
Phone: +41 31 350 95 42
Fax: +41 31 350 99 40
E-Mail: [EMAIL PROTECTED]
Switzerland is everywhere. Stay connected!
http://www.swissinfo.org
http://mobile.swissinfo.org
http://wap.swissinfo.org
SRG SSR id�e suisse
_______________________________________
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
