Re: [Ejbca-develop] DATABASE INIT failure!

[<sur...@ya...>]

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='A''
at line 1")
        at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:276)
        at
org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1299)
        at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
        at
sun.reflect.GeneratedMethodAccessor7.invoke(Unknown
Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
......

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='A'' at line 1"
......


 --- Tomas Gustavsson <to...@pr...> 的正文：> 
> Hi,
> I think I see the problem. JBoss 3.2.x has changed
> the configuration 
> files for the databases. The file mysql-service.xml
> provided with EJBCA 
> 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 
> 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=LocalTxDS,name=MySqlDS
> > 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)
> > ................
> 
>  

_________________________________________________________
Do You Yahoo!? 
启用电邮帐号，领会雅虎通[身临其境聊电影]的动感魅力，还有网络摄像头+雅虎通收音机等你来拿
http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.messenger.yahoo.com