Re: [Ejbca-develop] DATABASE INIT failure!

[Tomas G. <to...@pr...>]

This problem does not seem related to EJBCA for me. It's possible that
there are issues with the version of JBoss you are using and the JDBC
driver you are using.
I recomment searching for this error in the JBoss forums.

Regards,
Tomas


surd wrote:
> hi:
>   I have used
> $JBOSS_HOME/docs/examples/jca/mysql-ds.xml to replace
> mysql-service.xml and modified it according to my
> needs.
>   After jboss is started by run.sh, I can see tables
> have been created using mysql client. But still some
> errors follow:
> ......
> org.jboss.mq.SpyJMSException: Could not resolve
> uncommited transactions.  Message recovery may not be
> accurate; - nested throwable: (java.sql.SQLException:
> Syntax error or access violation,  message from
> server: "You have an error in your SQL syntax
> near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP=3D'A''
> at line 1")
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Persis=
tenceManager.java:276)
>         at
> org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManage=
r.java:1299)
>         at
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192=
)
>         at
> sun.reflect.GeneratedMethodAccessor7.invoke(Unknown
> Source)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso=
rImpl.java:25)
> ......
>=20
> Caused by: java.sql.SQLException: Syntax error or
> access violation,  message from server: "You have an
> error in your SQL syntax near 'SELECT TXID FROM
> JMS_TRANSACTIONS) AND TXOP=3D'A'' at line 1"
> ......
>=20
>=20
>  --- Tomas Gustavsson <to...@pr...> =B5=C4=D5=FD=CE=C4=A3=BA>=20
>=20
>>Hi,
>>I think I see the problem. JBoss 3.2.x has changed
>>the configuration=20
>>files for the databases. The file mysql-service.xml
>>provided with EJBCA=20
>>works with JBoss 3.0.x, I haven't tried MySQL with
>>3.2.x unforturnately.
>>
>>You will have to make a new configuration file for
>>JBoss 3.2.x and=20
>>MySQL. There should be some examples out there for
>>JBoss 3.2.x and MySQL.
>>EJBCA does not have any special needs, it only needs
>>a DefaultDS.
>>
>>Regards,
>>Tomas
>>
>>surd wrote:
>>
>>>hi:
>>>  I plan to write a simple HOWTO to share with
>>
>>all.
>>
>>>Can you help me?
>>>  I do the work step by step and errors are:
>>>....
>>>22:32:17,964 INFO  [ServiceConfigurator] Problem
>>>configuring service
>>>jboss.jca:service=3DLocalTxDS,name=3DMySqlDS
>>>org.jboss.deployment.DeploymentException: No
>>
>>Attribute
>>
>>>found with name: JndiName
>>>......
>>>
>>>22:32:37,347 ERROR [EntityContainer] Starting
>>
>>failed
>>
>>>org.jboss.deployment.DeploymentException: Error:
>>
>>can't
>>
>>>find data source: java:/DefaultDS; - nested
>>
>>throwable:
>>
>>>(javax.naming.NameNotFoundException: DefaultDS not
>>>bound)