Thanks for your advice. I've downloaded the firebird interclient, I still have an error but now it's very clear :
[interclient] Invalid argument: User and password connection properties are not set.
See API reference for exception interbase.interclient.InvalidArgumentException

The parameters of my connectionFactory seemed obsolete to you only because I used a 15-day old built Jboss.

Now, I've built the 20/11 snapshot, same exception. The problem is : Where to state properties for drivers which need them? Is it in the ??
(I've also tried different separation scheme ; \t... but same exception).

If I get it working, I'll contribute my configuration.

Vad

Thanks! That works... Well, at least Jboss can login into Interbase. However it's unclear for me how it can work, because after a very quick look at the interbase.interclient.Driver source code, I see this :

if(properties == null || properties.getProperty("user") == null || properties.getProperty("password") == null || properties.getProperty("user").equals("") || properties.getProperty("password").equals(""))
throw new InvalidArgumentException(ErrorKey.invalidArgument__connection_properties__no_user_or_password__);

So does it mean that jboss map "UserName" to "user"?...


Anyway, another problem arrose, but I guess this one is more a driver problem !

Start command executing: CREATE TABLE ProduitBean (ISIN VARCHAR(256), name VARCHAR(256), quotity INTEGER)
[2001-11-22 09:37:28,565,DefaultDS,DEBUG] Pool DefaultDS [0/0/10] destroyed object org.jboss.resource.adapter.jdbc.local.JDBCManagedConnection@5b675e.
[2001-11-22 09:37:28,565,CMP,DEBUG] interbase.interclient.DriverNotCapableException: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported
See API reference for exception interbase.interclient.DriverNotCapableException
[2001-11-22 09:37:28,575,CMP,DEBUG] Could not create table ProduitBean
interbase.interclient.DriverNotCapableException: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported.
See API reference for exception interbase.interclient.DriverNotCapableException
at interbase.interclient.Connection.prepareStatement(Connection.java:1202)
at org.jboss.resource.adapter.jdbc.local.ConnectionInPool.prepareStatement(ConnectionInPool.java:652)

After another look at the driver code I see this :
public synchronized Statement createStatement(int i, int j)
throws SQLException
{
throw new DriverNotCapableException(ErrorKey.driverNotCapable__jdbc2_not_yet_supported__);
}

public synchronized PreparedStatement prepareStatement(String s, int i, int j)
throws SQLException
{
throw new DriverNotCapableException(ErrorKey.driverNotCapable__jdbc2_not_yet_supported__);
}

So does it mean that Interbase is unusable with Jboss?

Vad

As I could not use the JDBC driver (see previous message), I've tried Sun JDBC-ODBC bridge and ODBC driver for Interbase from EasySoft. It works ! (although I consider it's only a waiting-for-best solution). But I have some questions about mappings, especially for java types Double and Object.

<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>VARCHAR(2000)</sql-type>

<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE PRECISION</sql-type>

do not give expected results...

Many thanks David, it works fine!

I will make more tests and I'll post or send you my config.

Vad