Paul Reeves wrote:

> nicolas.ocquidant@... wrote:
> >
> > Hi all,
> >
> > I have downloaded the classic version of firebird (for solaris) to use
> > with jboss.
> >
> > I try to access the database with these parameters:
> > <attribute
> > name="URL">jdbc:interbase://localhost/opt/dbs/storage/firebird/firebirdDBtest.gdb</attribute>
> > <attribute name="JDBCUser">SYSDBA</attribute>
> > <attribute name="Password">masterkey</attribute>
> >
> > The jboss forum has confirmed these options.
> >
> > My problem is :
> > Do I need to create the user SYSDBA and the password masterkey ?
> > And if yes, how ?
>
> SYSDBA/masterkey are the default username/password combo. They should be
> already defined. Beware, however, that the version you have installed may have
> changed the 'masterkey' password. Check in the root of the firebird install
> for documentation of the new password.
>
> Add/Modify/Delete users with GSEC.
>
> >
> > For the moment, i have only created a database with the isql utility
> > but it still doesn't work.
> >
>
> The standard connect string follows this format:
>
> hostname:/path/to/database.gdb
>
> or
> /path/to/database.gdb
>
> if you want a local connection.
>
> BTW, you will not get very far connecting to Firebird from JBoss unless you
> have interclient installed. This provides a server (called InterServer) to
> listen for calls from the class 3 InterClient driver on port 3060.
> Alternatively, there is a class 4 driver under development - you can extract
> it via CVS from the Firebird Project on Sourceforge.
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> taking InterBase further

Hi Paul,

SYSDBA and the password: masterkey seems to be defined because
i can launch: gsec -user SYSDBA -password masterkey

I have of course installed the interclient client.

It looks like jboss cannot get a connection to the database.

The parameters I used are:

<attribute name="URL">jdbc:interbase://localhost/opt/dbs/storage/firebird/firebirdDBtest.gdb</attribute>
<attribute name="JDBCUser">SYSDBA</attribute>
<attribute name="Password">masterkey</attribute>

I don't understand.
I'm going to post a message on the jboss forum.

Thamks a lot.


--
Nicolas Ocquidant - Geomath International
Tel. 01 47 08 82 77 - Fax. 01 47 08 82 48
232 avenue Napoleon Bonaparte
92500 Rueil Malmaison




[Non-text portions of this message have been removed]