Getting Firebird embedded working in java

how would i change the port number on the embedded version?

I managed to find a setting in the firebird.conf which says
RemoteServicePort

and i uncommented it and change it to look like this

RemoteServicePort = 3059

that gave me the same error as above

Ok i went back to what the readme file says to do and i uninstalled firebird 2.0 superserver and i get this error.


exception: Message-Unexpected exception caught. ToString-org.firebirdsql.gds.impl.jni.InternalError: Unexpected exception caught.
org.firebirdsql.gds.impl.jni.InternalError: Unexpected exception caught.
        at org.firebirdsql.gds.impl.jni.JniGDSImpl.native_isc_attach_database(Native Method)
        at org.firebirdsql.gds.impl.jni.BaseGDSImpl.iscAttachDatabase(BaseGDSImpl.java:118)
        at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:89)
        at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:470)
        at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:119)


I setup the file directly like it says in the readme
  c:\my_app\app.exe
  c:\my_app\gds32.dll
  c:\my_app\ib_util.dll
  c:\my_app\icudt30.dll
  c:\my_app\icuin30.dll
  c:\my_app\icuuc30.dll
  c:\my_app\firebird.conf
  c:\my_app\firebird.msg
  c:\my_app\intl\fbintl.dll
  c:\my_app\intl\fbintl.conf
  c:\my_app\udf\fbudf.dll

this didn't work either

did you restart the firebird service that relates to the firebird.conf file you changed, it's only read on startup

please try using isql as described, we need to decide if the problem is firebird or java

there is no service it's the embedded version

Yes isql can connect to it  i did not know if i was connected so i just ran a query to test(as i have never used isql yet)

Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT C:\zee03\Database\USERDB.FDB
CON> user 'SYSDBA' password 'masterkey';
Database:  C:\zee03\Database\USERDB.FDB, User: SYSDBA
SQL> SELECT COUNT(*) FROM ORDERS
CON> go;

       COUNT
============
           0

SQL>

Another thing i just found out was that if i change the connection string from

con = DriverManager.getConnection("jdbc:firebirdsql:embedded:C:\\zee03\\Database\\userdb.fdb", "sysdba", "masterkey");
           
to:

con = DriverManager.getConnection("jdbc:firebirdsql:localhost:C:\\zee03\\Database\\userdb.fdb", "sysdba", "masterkey");
           
All of the documentation at firebird says i should be using the embedded tag not localhost so i am assuming it's somehow using the installed firebird server to make the connection(not say i have any idea how this works thats just my guess).  

I want to use the embedded database in my application however so i should not have to install the server on my system just the files for the embedded version.

yes it's using which ever version you installed as a server, most commonly the server version is used for development as you can have multiple connection open at once, then embeded for deployment. I think the problem is that you are trying to have both embedded & server installed at once.

I would remove one (completely), get the other working, edit firebird.conf to move it's port, then install the other and get that working, once each work via isql you know it's just the java params that need to change

I have a problem, ehh if i uninstall firebird 2.0 superserver than i don't seem to have isql on my system and i can't seem to find it online to download anywhere. As it is not included with the embedded download package.  Do you know where i can find it.  

I do have flamerobin installed on my computer and no it cannot connect without the superserver installed on my computer it gives me an error.

Context: Database: Connect
Message: isc_attach_Database failed

SQL Message: -904
can't format message 13:96 --message c:\Program Files\firebird.msg  not found
Engine Code 335544375


This is kind of strange since i never installed firebird to the program files folder it was installed to the default folder
C:\Program Files\Firebird\Firebird_2_0\

ok i got a connection with flamerobin after installing a bunch of files and restarting it i got a connection to the database.

I tried connecting again with java same error

exception: Message-Unexpected exception caught. ToString-org.firebirdsql.gds.impl.jni.InternalError: Unexpected exception caught.
org.firebirdsql.gds.impl.jni.InternalError: Unexpected exception caught.
        at org.firebirdsql.gds.impl.jni.JniGDSImpl.native_isc_attach_database(Native Method)
        at org.firebirdsql.gds.impl.jni.BaseGDSImpl.iscAttachDatabase(BaseGDSImpl.java:118)
        at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:89)
        at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:470)
        at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:119)
        at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)

I could just be putting the embedded files in the wrong place
I am using netbeans as my IDE and it has the usual folder arrangement

My Project
     build
     dist
     nbproject
     src
     test


I placed my embedded files in the My Project folder which now looks like this

My Project
     build
     dist
     intl  --firebird embedded folder
     nbproject
     src
     test
     udf --firebird embedded folder
    fbembed.dll -- embedded file
    gds32.dll  -- embedded file
    fbclient.dll --embedded file
    jaybird21.dll -- embedded file