Subject | Re: [firebird-support] Help accessing FB in win98 |
---|---|
Author | Francisco Antonio Vieira Souza |
Post date | 2004-09-13T09:24:13Z |
Paul Vinkenoog wrote:
{
Connection c = null;
String maquina = "";
try
{
maquina = getCaminhoServidor(); /* localhost or 192.168.0.1,
192.168.0.2 ... */
}
catch(Exception io){}
String user = "SYSDBA";
String pwd = "masterkey";
String dir_db = "C:\\Kooky\\SiGet\\dados\\SIGET.FDB";
String url =
"jdbc:firebirdsql:"+maquina+"/3050:"+dir_db+"?lc_ctype=ISO8859_1";
try{
c = java.sql.DriverManager.getConnection (url, user,
pwd);
}
catch(org.firebirdsql.jdbc.FBSQLException ef)
{
ef.printStackTrace();
TG.Mess("Erro FB/SQL: Pegando a Conexão",ef.getMessage());
return null;
}
catch(SQLException eee)
{
eee.printStackTrace();
TG.Mess("Erro SQL - Pegando a Conexão",eee.getMessage());
return null;
}
return c;
}
This after registering the driver successfully.
get the Exception I will show below.
code 335544352 found.
null
null
null
Reason: No message for code 335544352 found.
null
null
null
at
org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:185)
at
org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at
org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at
org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:251)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:127)
at br.com.lib.TDB.getCon(TDB.java:128)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:70)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)
at org.firebirdsql.gds.GDSException: No message for code 335544352 found.
null
null
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1759)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1712)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:297)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:259)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:540)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:88)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:366)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:158)
at
org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at
org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at
org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:251)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:127)
at br.com.lib.TDB.getCon(TDB.java:128)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:70)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)
java.lang.NullPointerException
at
br.com.modulos.conhecimentos.getConhecimentos(conhecimentos.java:556)
at br.com.modulos.conhecimentos.setAmbiente(conhecimentos.java:687)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:137)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)
> Hi Francisco,Thank you very much for your answer.
>
> > What is the trick about installing and running FB 1.5.1 in win98??
>
> There should be no "trick" necessary.
>
> > When in WinXP, everything works fine, but in Win98 SE, the
> > connection just cant be completed, using application made with java
> > (with Jaybird JDBC).
>
> I don't know what's wrong, but I'd first check if the server is up and
> running. Have you tried connecting with isql, or other native admin
> tools? If that works, it must be something in the Java driver. Or in
> your app.
>public static Connection getCon()
> Wherever the problem lies, people here will only be able to help you
> if you give more information:
> - how exactly did you (try to) connect?
{
Connection c = null;
String maquina = "";
try
{
maquina = getCaminhoServidor(); /* localhost or 192.168.0.1,
192.168.0.2 ... */
}
catch(Exception io){}
String user = "SYSDBA";
String pwd = "masterkey";
String dir_db = "C:\\Kooky\\SiGet\\dados\\SIGET.FDB";
String url =
"jdbc:firebirdsql:"+maquina+"/3050:"+dir_db+"?lc_ctype=ISO8859_1";
try{
c = java.sql.DriverManager.getConnection (url, user,
pwd);
}
catch(org.firebirdsql.jdbc.FBSQLException ef)
{
ef.printStackTrace();
TG.Mess("Erro FB/SQL: Pegando a Conexão",ef.getMessage());
return null;
}
catch(SQLException eee)
{
eee.printStackTrace();
TG.Mess("Erro SQL - Pegando a Conexão",eee.getMessage());
return null;
}
return c;
}
This after registering the driver successfully.
>The system runs but when I try to get the connection as shown above I
> - what happened then: an error message? nothing? an application
> freeze-up?
get the Exception I will show below.
>org.firebirdsql.jdbc.FBSQLException: Resource Exception. No message for
> - if there was an error message, what did it say *exactly*?
code 335544352 found.
null
null
null
Reason: No message for code 335544352 found.
null
null
null
at
org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:185)
at
org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at
org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at
org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:251)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:127)
at br.com.lib.TDB.getCon(TDB.java:128)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:70)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)
at org.firebirdsql.gds.GDSException: No message for code 335544352 found.
null
null
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1759)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1712)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:297)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:259)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:540)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:88)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:366)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:158)
at
org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at
org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at
org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSource.java:251)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:127)
at br.com.lib.TDB.getCon(TDB.java:128)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:70)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)
java.lang.NullPointerException
at
br.com.modulos.conhecimentos.getConhecimentos(conhecimentos.java:556)
at br.com.modulos.conhecimentos.setAmbiente(conhecimentos.java:687)
at br.com.modulos.conhecimentos.<init>(conhecimentos.java:137)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at br.com.main.SigetFrame.setExecutarJanelas(SigetFrame.java:733)
at br.com.main.SigetFrame.<init>(SigetFrame.java:165)
at br.com.main.Main.main(Main.java:29)