HSQL DataSource in WSAD 5 ("null RelationResourceAdapter"???)

[Bruce Sams]

Hello,

I have a running HSQL database which I want to connect to using a jndi
DataSource. I have added the datasource to the server configuration
file
so that the source should be available under the name "jndi/hsqlds"
relaive to java:comp/env. When I start the server, I get the error
message that the
DataSource "has a null RelationResourceAdapter". Ugh! How can I fix
that?

The server configuration file (resources.xml) and the relevent part of
the error mesage are shown below.

I would be grateful for any help/tips on this matter, as I am going
BANANAS
trying to get it to work.

Thanks,
Bruce

*************************CONFIG FILE ****************************

<resources.jdbc:JDBCProvider xmi:id="JDBCProvider_1"
name="HSQL_JDBC_Provider" description="User-defined JDBC Provider"
implementationClassName="org.hsqldb.jdbcDataSource">
<classpath>E:\work\wsad\workspace_mt_test\HSQL
Server\lib\hsqldb.jar</classpath>
<factories xmi:type="resources.jdbc:DataSource"
xmi:id="DataSource_1" name="HSQL_DataSource" jndiName="jndi/hsqlds"
description="HSQLDB DataSource" category="" authDataAlias="HSQL Sys
Admin" statementCacheSize="10"
datasourceHelperClassname="com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper">
<propertySet xmi:id="J2EEResourcePropertySet_1">
<resourceProperties xmi:id="J2EEResourceProperty_1" name="URL"
type="java.lang.String" value="jdbc:hsqldb:hsql://localhost:9001"
description="URL to the DB">
<required xsi:nil="true"/>
</resourceProperties>
</propertySet>
<connectionPool xmi:id="ConnectionPool_1"
connectionTimeout="1800" maxConnections="10" minConnections="1"
reapTime="180" unusedTimeout="1800" agedTimeout="1800"
purgePolicy="EntirePool"/>
<mapping xmi:id="MappingModule_1"
mappingConfigAlias="DefaultPrincipalMapping" authDataAlias="HSQL Sys
Admin"/>
</factories>
</resources.jdbc:JDBCProvider>

***************************ERROR MESSAGE*************************+
[3/4/03 16:51:22:150 CET] 66974d7a ResourceMgrIm E WSVR0017E: Error
encountered binding the J2EE resource, HSQL_DataSource, as jndi/hsqlds
from resources.xml
com.ibm.ws.runtime.component.binder.ResourceBindingException: invalid
configuration passed to resource binding logic. REASON: Invalid
Configuration! The DataSource: HSQL_DataSource has a null
RelationResourceAdapter property.
at com.ibm.ws.runtime.component.binder.ResourceBinderImpl.checkRequiredProperty(ResourceBinderImpl.java:45)