db/hypersonic/default.script stores data.

[roysun]

I am going to use entity bean writing data to Postgres db table. But I find all data are stored in jboss/hypersonic/default.script file instead of in database. I guess something wrong with configuration. Could you help please.

Roy

[adrian.brock]

Read this.

http://hsqldb.sourceforge.net/internet/hSqlFAQ.html

Regards,
Adrian

[roysun]

Thanks. It seems by design for safety.
At the end of .script file shows me "ROLLBACK". Is that means Database operation failed?

Roy

[adrian.brock]

I don't know the details of the script file.
But I would guess the last operation failed, yes.

Regards,
Adrian

[roysun]

I am strugglling for connecting Postgres db. My postgres-service.xml like following. Anything wrong with it?

==============================




ConnectionURL=jdbc:postgresql://rtest.inquent.com:5432/iqos
AutoCommit=true
DriverClass=org.postgresql.Driver
UserName=rsun
Password=

IqosPostgresDS
java:/TransactionManager
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter</mbean-ref>
<mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedXAMFactory</mbean-ref>
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=500000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping

UserName=

[roysun]

Do I need to specify JdbcProvider in postgres-service.xml?
Roy