Hi, everyone!
I am new to Orion and I am trying to deploy my (test) application. However,
I have some problems. When running my client I get the following exception
(pasted from application.log):
2000-11-07 13:21 Error in bean Account
interbase.interclient.InvalidOperationException: [interclient] Invalid
operation to commit or rollback a transaction while in auto-commit mode.
See API reference for exception interbase.interclient.InvalidOperationException
at interbase.interclient.Connection.rollback(Unknown Source)
at com.evermind.sql.an.rollback(JAX)
at com.evermind.sql.an.rollback(JAX)
at com.evermind.server.ejb.DataSourceConnection.rollback(JAX)
at
Account_EntityBeanWrapper2.loadState(Account_EntityBeanWrapper2.java:835)
at
AccountHome_EntityHomeWrapper5.findExistingEntity(AccountHome_EntityHomeWrapper5.java:37)
at
AccountHome_EntityHomeWrapper5.findByPrimaryKey(AccountHome_EntityHomeWrapper5.java:225)
at java.lang.reflect.Method.invoke(Native Method)
at com.evermind.server.rmi.bd.run(JAX)
at com.evermind.server.rmi.bb.hy(JAX)
at com.evermind.server.rmi.bb.run(JAX)
at com.evermind.util.f.run(JAX)
I use Interbase as database and somehow the database seems to be in
autocommit mode when Orion tries to commit or rollback a transaction. This
seems strange to me, because I believe that Orion should turn off
autocommit for all connections. Any clues to why I receive this exception?
My data-sources.xml looks as follows:
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">
<data-sources>
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Default Interbase"
schema="database-schemas/Interbase.xml"
location="jdbc/InterbaseCoreDS"
xa-location="jdbc/xa/InterbaseXADS"
ejb-location="jdbc/InterbaseDS"
connection-driver="interbase.interclient.Driver"
username="user"
password="password"
url="jdbc:interbase://localhost/d:/tmp/databases/Ejb-orion.gdb"
inactivity-timeout="30"
/>
</data-sources>
The database schema file Interbase.xml looks as follows:
<?xml version="1.0"?>
<!DOCTYPE database-schemea PUBLIC "-//Evermind//- Database scheme"
"http://www.orionserver.com/dtds/database-schemes.dtd">
<database-schema name="Interbase" not-null="not null" null=""
primary-key="primary key">
<type-mapping type="java.lang.String" name="varchar(252)" />
<type-mapping type="int" name="integer" />
<type-mapping type="long" name="numeric(18,0)" />
<type-mapping type="float" name="float" />
<type-mapping type="double" name="double precision" />
<type-mapping type="byte" name="smallint" />
<type-mapping type="char" name="char" />
<type-mapping type="short" name="smallint" />
<type-mapping type="boolean" name="smallint" />
<type-mapping type="java.sql.Date" name="date" />
<type-mapping type="java.sql.Time" name="time" />
<type-mapping type="java.sql.Timestamp" name="timestamp" />
<type-mapping type="java.io.Serializable" name="varchar(2000)" />
<disallowed-field name="user" />
<disallowed-field name="password" />
<disallowed-field name="date" />
</database-schema>
I have the following configuration of my system:
JDK 1.3
Orionserver 1.3.8
Interbase 6.01
Interclient 1.6
WinNT 4.0 SP 6
I know from other messages on this list that some of you actually uses
Interbase together with Orion. What did you do to make it work? How does
your data-sources.xml look like??
----
Håkan Axelsson E-mail: [EMAIL PROTECTED]
Object Technology Mentoring Phone: +46 8 507 142 59
Enea Business Software AB Fax: +46 8 658 57 90
Hornsgatan 166, S-117 28 Täby, Sweden WWW: www.enea.se
