Thanks, I have checkout the source from CVS and build a new
firebirdsql.jar and its OK.

But now I have another problem. I need to set up a firebird
connection pool in JBoss 3.0. I have try to use firebirdsql.jar and
set up a JDBC connection pool with UNICODE support. Its OK when I
specify the URL as follows:

jdbc:firebirdsql://localhost//home/databases/sample.gdb?lc_ctype=UNICODE_FSS

Then, I want to try firebirdsql.rar (I have build a new one from CVS)

I have made neccessary changes to Firebird-service.xml and if the
Database config-property is specified either

localhost/3050:/home/databases/sample.gdb

or

//localhost//home/databases/sample.gdb

It is OK, but without UNICODE support.

So I try, either

localhost/3050:/home/databases/sample.gdb?lc_ctype=UNICODE_FSS

or

//localhost//home/databases/sample.gdb?lc_ctype=UNICODE=FSS

The Firebird-service.xml can be deployed. But when I access the
connection pool, both case failed with the following exception

INFO [FBManagedConnectionFactory] Could not get a db connection!
org.firebirdsql.gds.GDSException: I/O error for file %.0s"open"
null
Error while trying to open file
null
null
Error while trying to open file
null
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1429)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1350)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:274)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:247)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:541)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:113)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:334)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:236)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:101)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:312)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:467)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:532)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:97)
......
ERROR [STDERR] java.sql.SQLException: Problem getting connection:
javax.resource.ResourceException: could not get a db connection!
ERROR [STDERR] at
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:100)
......

Please help
Thanks
CN

--- In Firebird-Java@y..., "rrokytskyy" <rrokytskyy@y...> wrote:
> > But I need the URL-encoded form to work. Can anybody help? Am I need
> > to apply any patch?
>
> You need to get driver's code from CVS and build it yourself. beta 1
> release does not include this feature.
>
> Best regards,
> Roman Rokytskyy