[jboss-user] [jBPM] - Re: MySQL database connection error

Zoltan Papp do-not-reply at jboss.com
Thu Mar 14 12:01:04 EDT 2013


Zoltan Papp [https://community.jboss.org/people/pzoli] created the discussion

"Re: MySQL database connection error"

To view the discussion, visit: https://community.jboss.org/message/802725#802725

--------------------------------------------------------------
>  *And the second is a MySQL exception, there a lots of tables missings like:*
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_24]
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.6.0_24]
>     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.6.0_24]
>     at java.lang.reflect.Constructor.newInstance(Constructor.java:532) [rt.jar:1.6.0_24]
>     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>     at com.mysql.jdbc.Util.getInstance(Util.java:386)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
>     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
>     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
>     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
>     at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
>     at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:149) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:457) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>     at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>     at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>     at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>     at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)
>     at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
>     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24]
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]
>     at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
> 
> *My questions are:* 
> *Should I create the MySQL DB schema (I thin I should), and if I should where can I find an SQL script for this?*
> *The first error  also caused by the DB error?*
> 
> Thanks for your help!
> 
> Best Regards,
> 
> Csaba

Kedves Csaba!

A sequences táblát azért keresi, mert egyedi azonosítót adtál egy táblának, de nincs -vagy rossz- generálási stratégiát adtál hozzá.

@Entity -> @Id -> @GeneratedValue(strategy=GenerationType.IDENTITY)
Dobd el előtte a táblákat, hogy újra létrehozza ezeket az entitás tárolókat, és beállítsa a kulcs mezőt a táblára.

üdv.,
Zoltán
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/802725#802725]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130314/976c0075/attachment.html 


More information about the jboss-user mailing list