Hi all,
I've been trying to start the orion server with postgresql but I can't
get it working.
What I did is as follows:
1. Copied 'postgresql.jar' driver to '/usr/local/orion/lib' directory.
2. Modified '/usr/local/orion/config/data-sources.xml'
----------
The modified 'data-sources.xml' follows:
<data-sources>
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="PostGreSQL"
location="jdbc/postgresql"
xa-location="jdbc/xa/postgresql"
ejb-location="jdbc/postgresql"
connection-driver="org.postgresql.Driver"
username="postgres"
password="password"
url="jdbc:postgresql://xxx.xxx.xxx.xxx:5432/mydb"
inactivity-timeout="30"
/>
</data-sources>
And the error message follows:
[root@localhost orion]# java -jar orion.jar
Auto-deploying addressbook (New server version detected)...
Auto-deploying addressbook-ejb.jar (No previous deployment found)... SQL
error: ERROR: parser: parse error at or near ")"
Auto-creating table: create table addressbook_ejb_AddressEntry (name
varchar(255) not null primary key, address varchar(255) null, city
varchar(255) null)
Warning: Error creating table: ERROR: parser: parse error at or near
"null"
done.
Orion/1.3.8 initialized
--------------
Yes, I was testing the addressbook sample code which was in the orion
site. And don't worry about
any typographical error in the above messages, if any, because I just
typed it in myself.
(No copy & paste) Because I don't know how to copy and paste in RedHat
6.1 Gnome and Enlightment.
If anybody knows how, please let me know that too. I am going to be very
grateful. (copying from xterm and
pasting to netscape). Back to our topic... I believe that I
misconfigured something.
When I worked on Sun's j2ee app. server, it had a similar problem.
Unfortunately, postgresql doesn't
seem to differentiate cases, but ejb does. Even if I create a table in
upper cases in postgresql, postgresql
rewrites the names of the tables in all lower cases. So what I did with
Sun's j2ee, I manually
changed table names and field names with all CMP beans.
I greatly appreciate you time. Hapy happy Halloween......... ;-P
Seung