Subject | Re: connect would work better |
---|---|
Author | Jean Noël Martin |
Post date | 2010-10-29T13:49:18Z |
hello
I can give you the source code of the high level usage of the connection to avoid misunderstatment
if (!FBDriverLoaded) { // don't load Jaybird more than once.
{
try
{
Class.forName("org.firebirdsql.jdbc.FBDriver");
org.firebirdsql.pool.FBConnectionPoolDataSource dataSource = new org.firebirdsql.pool.FBConnectionPoolDataSource();
if( dataSource != null )
{
FBDriverLoaded = true;
}
dataSource.setMaxStatements( 10);
dataSource.setMaxIdleTime( 30* 60 * 60);
dataSource.setPooling(true);
dataSource.setMaxPoolSize( 5);
dataSource.setMinPoolSize( 2);
dataSource.setLoginTimeout( 10000);
dataSource.setDatabase ("localhost:E:\\Program Files\\Borland\\bin\\COHERENCE");
dataSource.setPassword("masterkey");
dataSource.setUserName("SYSDBA");
PooledConnection pooledConnection = dataSource.getPooledConnection();
connect = pooledConnection.getConnection();
}
catch (SQLException ex)
{
Logger.getLogger(JNMImportAction.class.getName()).log(Level.SEVERE, null, ex);
}
catch( IllegalArgumentException e)
{
e.printStackTrace();
}
if( cnx != null )
{
returnValue = true; }
else
{
returnValue = false;
}
}
I can give you the source code of the high level usage of the connection to avoid misunderstatment
if (!FBDriverLoaded) { // don't load Jaybird more than once.
{
try
{
Class.forName("org.firebirdsql.jdbc.FBDriver");
org.firebirdsql.pool.FBConnectionPoolDataSource dataSource = new org.firebirdsql.pool.FBConnectionPoolDataSource();
if( dataSource != null )
{
FBDriverLoaded = true;
}
dataSource.setMaxStatements( 10);
dataSource.setMaxIdleTime( 30* 60 * 60);
dataSource.setPooling(true);
dataSource.setMaxPoolSize( 5);
dataSource.setMinPoolSize( 2);
dataSource.setLoginTimeout( 10000);
dataSource.setDatabase ("localhost:E:\\Program Files\\Borland\\bin\\COHERENCE");
dataSource.setPassword("masterkey");
dataSource.setUserName("SYSDBA");
PooledConnection pooledConnection = dataSource.getPooledConnection();
connect = pooledConnection.getConnection();
}
catch (SQLException ex)
{
Logger.getLogger(JNMImportAction.class.getName()).log(Level.SEVERE, null, ex);
}
catch( IllegalArgumentException e)
{
e.printStackTrace();
}
if( cnx != null )
{
returnValue = true; }
else
{
returnValue = false;
}
}
--- In Firebird-Java@yahoogroups.com, Jean Noël Martin <jnm53@...> wrote:
>
> hi
> I checked step 1 and 2
> 1 consist in tool library
> 2 consist in Service Driver
> The two are completed
> however the result remain unusuable I go the IllegalArgumentException e = specified GDS Type null is unknown.
>
> --- In Firebird-Java@yahoogroups.com, "Mark Rotteveel" <Avalanche1979@> wrote:
> >
> > > Ok I read you;
> > > However I use the source of Jaybird becausa NetBean don't recognize the
> > > import instructions with only the Jar file....
> >
> > Then you really are doing something wrong in Netbeans. I think you simply forgot to add the library to your project. Step 1 is creating a user library for Jaybird in Netbeans (which I think you did), step 2 is adding that library to your current project (which I you forgot to do). After that imports should just work. There is never a good reason to need to include the source of a dependency into your own program.
> >
> > Mark
> > --
> > Neu: GMX De-Mail - Einfach wie E-Mail, sicher wie ein Brief!
> > Jetzt De-Mail-Adresse reservieren: http://portal.gmx.net/de/go/demail
> >
>