I'm not familiar with InterClient but it was my understanding that as a
solution is was "less than optimal" too be kind. Also, I find it
'interesting' that your using the remote (localhost) interface and not
the local interface access ("jdbc:interbase:+path+"IBExport.gdb").

Next, have you tried using the ODBC driver to access Interbase?


Sean

P.S. By the way, watching the over quoting...

> -----Original Message-----
> From: pmoon7@... [mailto:pmoon7@...]
> Sent: Friday, June 01, 2001 5:41 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: prepared insert
>
>
> if(driverNameWrite=="JDBC")
> { Class.forName("interbase.interclient.Driver");
> String urlPath =
> GenMain.class.getResource("GenMain.class").getFile();
> int trailPathLength = urlPath.length() -
> "cls/Generic/GenMain.class".length();
> String path = urlPath.substring(1, trailPathLength);
>
> String URL = "jdbc:interbase://localhost/"+path+"IBExport.gdb";
> ibDataSource.setSweepOnConnect(false);
> connectionWrite =
> ibDataSource.getConnection("sysdba","masterkey");
> connectionWrite.setAutoCommit(false);
> }
>
> Thanks for the response! The above codes is how I made the
> connection. Everything seem to be in order. My last option
> may be to
> go with delphi.
>