Hi,
You have to hack the config/database-schemas/postgresql.xml
changing the null="null" to null="".
This works fine.
[]s
Guilherme Ceschiatti
[EMAIL PROTECTED]
On Tue, Oct 31, 2000 at 06:11:49PM -0800, Seung Bang wrote:
> 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
>
>
>
>
>
