Problems in create an EntityBean with orion and hypersonic DB

[Yossi Shmulevitch]

hi all!!

I'm trying to connect through a client already deployed entity bean.
I'm getting this error message(in the server log):


java.sql.SQLException: User not found: ADMIN
        at org.hsql.Trace.getError(Trace.java:124)
        at org.hsql.Trace.getError(Trace.java:115)
        at org.hsql.Trace.error(Trace.java:130)
        at org.hsql.Access.get(Access.java:109)
        at org.hsql.Access.getUser(Access.java:88)
        at org.hsql.Database.connect(Database.java:60)
        at
org.hsql.jdbcConnection.openStandalone(jdbcConnection.java:662)
        at org.hsql.jdbcConnection.<init>(jdbcConnection.java:524)
        at org.hsql.jdbcDriver.connect(jdbcDriver.java:78)
        at com.evermind.sql.DriverManagerDataSource.getConnection(JAX)
        at
com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(JAX)

        at com.evermind.sql.OrionPooledDataSource.c7(JAX)
        at com.evermind.sql.OrionPooledDataSource.cw(JAX)
        at com.evermind.sql.OrionPooledDataSource.getConnection(JAX)
        at com.evermind.sql.DriverManagerXADataSource.df(JAX)
        at com.evermind.sql.ag.dc(JAX)
        at com.evermind.sql.ak.rollback(JAX)
        at com.evermind.server.ejb.DataSourceConnection.close(JAX)
        at EntityHomeWrapper1.create(EntityHomeWrapper1.java:482)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.evermind.server.rmi.ba.run(JAX)
        at com.evermind.server.rmi.a8.gu(JAX)
        at com.evermind.server.rmi.a8.run(JAX)
        at com.evermind.util.e.run(JAX)


Is the orion server not creating users in the hypersonic db by himself?

My ($ORION)/config/data-source.xml look like this:



<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">

<data-sources>

        <data-source
                name="Default data-source"
                class="com.evermind.sql.ConnectionDataSource"
                location="jdbc/DefaultDS"
                pooled-location="jdbc/DefaultPooledDS"
                xa-location="jdbc/xa/DefaultXADS"
                ejb-location="jdbc/DefaultEJBDS"
                url="jdbc:HypersonicSQL:defaultdb"
                connection-driver="org.hsql.jdbcDriver"
                username="admin"
                password="12345678"
                schema="./database-schemas/hypersonic.xml"
        />

</data-sources>




Please notice that the hypersonic db searches for the uppercase  word
"ADMIN" instead of admin.


thanks ,
            yossi shmulvitch
            [EMAIL PROTECTED]