Hi there
Be so kind and tell me the following:
Does OrionServer include a Transaction Manager or do we have to use a 3rd
party product?
If we have to use a 3rd party product - can you recommend any?
What way/process do you suggest to go about editing the orion-ejb-jar.xml
file? It seems like OrionServer is respecting changes made to this file
while recreating it during deployment. Do you have more information about
hot-swopping applications and re-deploying applications?
I'm using PostgreSQL on Linux for the database. After changes some of the
incorrect mappings in the postgres-schema xml file (data-source and schema
below) it works fine except for one little thing: It gives an SQL error just
before auto creating the tables (see sniplet below)
Otherwise things look great.
Thank you in advance
Regards
Theo
<!-------SNIP--------->
icecube:/usr/local/orion# /usr/local/java/bin/java -jar orion.jar
Auto-deploying ice...
Auto-deploying ice-ejb... SQL error: ERROR: parser: parse error at or near
")"
Auto-creating table: create table Location (id int4 not null primary key,
name varchar, type int4, parent_ int4)
<!-------/SNIP--------->
<!-------SNIP--------->
<data-source
name="icetest-data-source"
class="com.evermind.sql.ConnectionDataSource"
schema="database-schemas/postgresql.xml"
url="jdbc:postgresql:testdb"
connection-driver="org.postgresql.Driver"
location="jdbc/DefaultDS"
ejb-location="jdbc/DefaultEJBDS"
xa-location="jdbc/xa/DefaultXADS"
username="postgres"
password="blah"
/>
<!-------/SNIP--------->
<!-------SNIP--------->
<database-scheme name="PostGreSQL" not-null="not null" null=""
primary-key="primary key">
<type-mapping type="java.lang.String" name="varchar" />
<type-mapping type="java.lang.Integer" name="int8" />
<type-mapping type="int" name="int4" />
<type-mapping type="long" name="int8" />
<type-mapping type="float" name="float4" />
<type-mapping type="double" name="float8" />
<type-mapping type="byte" name="int2" />
<type-mapping type="char" name="char" />
<type-mapping type="short" name="int2" />
<type-mapping type="boolean" name="bool" />
<type-mapping type="java.util.Date" name="date" />
<type-mapping type="java.io.Serializable" name="oid" />
<type-mapping type="java.math.BigDecimal" name="decimal" />
<disallowed-field name="parent" />
<disallowed-field name="password" />
<disallowed-field name="username" />
<disallowed-field name="date" />
<disallowed-field name="order" />
<disallowed-field name="old" />
<disallowed-field name="user" />
</database-scheme>
<!-------/SNIP--------->
