I downloaded the latest binary just a few days ago. Its marked
ejboss1.0PR2, so I guess version 1 pre release 2? I wish I could supply
more helpfull information aboutht e SQL parse errors, but they scroll off
too fast for me to see. The common theme, however, was that there is a
comma somewhere that create table didn't like...
I'm in the process of deploying my own entity beans. If I can pin it down,
I'll post to the list.
Thanks again for your help! Ite pretty uncommon to be able to get
desperatly needed help after 2:00AM!
Jim
--On Saturday, May 06, 2000 5:09 PM +1000 Joe Shevland
<[EMAIL PROTECTED]> wrote:
> Must admit I haven't tried it yet, will do soon though. Is that 1 or 2
> you're working with?
>
> Joe
>
> Jim Archer wrote:
>>
>> Thanks, Joe...
>>
>> The problem was the case in PostgreSQL. As you suggested, it didn't like
>> that at all! I set it to lower case and it worked. I had actually tried
>> the url against my localhost and the remote server, just to see if there
>> would be a difference, but there was not. Of course, as you said I want
>> to use it with a hostname.
>>
>> Thanks also for the test server info.
>>
>> When I start the server, it seems that EJBoss tries to make tables and I
>> get lots of SQLExceptions complaining of parser errors. This happens on
>> my own server and the test server you sent. Interestingly, the only
>> beans it tries to deploy are the ones in the test suite that ship with
>> EJBoss, and these work fine with HypersonicSQL.
>>
>> Thanks again!
>>
>> Jim
>>
>> --On Saturday, May 06, 2000 4:29 PM +1000 Joe Shevland
>> <[EMAIL PROTECTED]> wrote:
>>
>> > Jim Archer wrote:
>> >>
>> >> Hi All...
>> >>
>> >> I'm trying to get EJBoss to work with my Postgresql server (postgresql
>> >> 6.5.x). I comented out the Hypersonic SQL stuff and added this to the
>> >> conf.properties file in the /conf dir:
>> >>
>> >> database.vendor=2
>> >> database.url=jdbc:PostgreSQL:test
>> >
>> > You'd probably want something like:
>> >
>> > database.url=jdbc:PostgreSQL://hostname_or_ip/test
>> >
>> > to point to a remote machine (Postgres doesn't come on Windows as far
>> > as I know). The driver name looked correct, possible trying the
>> > name 'PostgreSQL' in lowercase may help? e.g. try this one for a
>> > brief test to see if it'll work:
>> >
>> > database.url=jdbc:postgresql://www.kpi.com.au/ejboss
>> > database.driver.classname=postgresql.Driver
>> > database.connection.username=ejboss
>> > database.connection.password=ejboss
>> >
>> > [snipped]
>> >
>> > Regards,
>> > Joe
>> >
>> >
>> > --
>> > --------------------------------------------------------------
>> > To subscribe: [EMAIL PROTECTED]
>> > To unsubscribe: [EMAIL PROTECTED]
>> > Problems?: [EMAIL PROTECTED]
>>
>> --
>> --------------------------------------------------------------
>> To subscribe: [EMAIL PROTECTED]
>> To unsubscribe: [EMAIL PROTECTED]
>> Problems?: [EMAIL PROTECTED]
>
> --
> Joe Shevland
> Principal Consultant
> KPI Logistics Pty Ltd
> http://www.kpi.com.au
> mailto:[EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
