Do you use a properties object to connect to the DB? If not, try that first. I don't think we need any more functionality in jdbcDriver as we support all the requirements for java.sql.Driver interface. If you want to investigate this further, add some form of logging to the jdbcDriver methods and see how they are called.
Fred ----- Original Message ----- From: "Blaine Simpson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 14 February 2003 20:44 Subject: [Hsqldb-developers] WebSphere data source When I try to add jdbcDriver as a JDBC Provider to WebSphere 5.0, I get errors like [2/14/03 15:22:59:164 EST] d895c84 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for org.hsqldb.jdbcDriver: 'URL'. [2/14/03 15:22:59:331 EST] d895c84 WSRdbDataSour W DSRA8020E: Warning: property not found for org.hsqldb.jdbcDriver: 'user'. [2/14/03 15:22:59:340 EST] d895c84 WSRdbDataSour W DSRA8020E: Warning: property not found for org.hsqldb.jdbcDriver: 'password'. [2/14/03 15:22:59:585 EST] d895c84 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/localdb, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: org.hsqldb.jdbcDriver WebSphere uses JMX to manage stuff, so I suspect that it wants to use getter/setter properties to set URL, username and password. I am thinking that I could possibly satisfy WebSphere by subclassing jdbcDriver (or making a wrapper class if private vars or anything else makes subbing difficult) and implementing MBean and giving it the getter/setter methods that WebSphere wants. WebSphere also says that they support "JDBC2.0-compliant" providers. I don't know whether they really enforce that. Anybody have any insight? ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
