Re: error in hibernate persistance service
Maurizio Brilli <[email protected]> Fri, 02 Jul 2004 18:40:27 +0200
| Newsgroups | gmane.comp.java.keel.user |
|---|---|
| Message-ID | <[email protected]> |
Aleks,
by following Shash' suggestion I made a small step ahead, though I'm not
able to get anything to work, yet.
I disabled the app-poll and rebuilt. Then, after realizing I needed the
jta jar or I'd never had it working (it took me two hours to realize
that... hehehe), I ended up into a new sort of error:
Unable to create database tables:null, Persistence exception while
creating default data for 'ids.ids', adding
name:ids.ids,table_name:ids,field_values:table_name=KeelListItem
I've had this after having switched from hsqldb to mysql, as I wasn't
sure the hsqldb configuration was allright and I had no way to check it.
Instead, about the mysql, I'm sure it works and that the parameters are
correct.
I enclose some info I had from the tomcat log (sorry for the length, but
I suppose it's necessary):
2-lug-2004 18.33.23 net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
configure
INFO: Using Hibernate built-in connection pool (not for production use!)
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
configure
INFO: Hibernate connection pool size: 20
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
configure
INFO: using driver: com.mysql.jdbc.Driver at URL:
jdbc:mysql://localhost/keel
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
configure
INFO: connection properties: {user=sa, password=}
2-lug-2004 18.33.23 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: Running hbm2ddl schema update
2-lug-2004 18.33.23 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: fetching database metadata
2-lug-2004 18.33.23 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: updating schema
2-lug-2004 18.33.23 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-many association mappings
2-lug-2004 18.33.23 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing one-to-one association property references
2-lug-2004 18.33.23 net.sf.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
close
INFO: cleaning up connection pool: jdbc:mysql://localhost/keel
2-lug-2004 18.33.23 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
2-lug-2004 18.33.23
net.sf.hibernate.connection.DriverManagerConnectionProvider
close
INFO: cleaning up connection pool: jdbc:mysql://localhost/keel
Hibernate: select ids0_.table_name as table_name, ids0_.next_id as
next_id from
ids ids0_ where (ids0_.table_name='KeelListItem' )
2-lug-2004 18.33.23 net.sf.hibernate.util.JDBCExceptionReporter
logExceptions
AVVERTENZA: SQL Error: 1146, SQLState: S1000
2-lug-2004 18.33.23 net.sf.hibernate.util.JDBCExceptionReporter
logExceptions
GRAVE: General error, message from server: "Table 'keel.ids' doesn't exist"
2-lug-2004 18.33.23 net.sf.hibernate.util.JDBCExceptionReporter
logExceptions
AVVERTENZA: SQL Error: 1146, SQLState: S1000
2-lug-2004 18.33.23 net.sf.hibernate.util.JDBCExceptionReporter
logExceptions
GRAVE: General error, message from server: "Table 'keel.ids' doesn't exist"
2-lug-2004 18.33.23 net.sf.hibernate.JDBCException <init>
GRAVE: Could not execute query
java.sql.SQLException: General error, message from server: "Table
'keel.ids' do
esn't exist"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1697)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1083)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1142)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1876)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1590)
Please let me know if you see what's wrong.
Thank you very much
Ciao
Maurizio