Re: error in hibernate persistance service

That looks not too bad... OK, the ID table is missing, but this means:

1. you didn't execute the "createdb" model
2. for some reason the persistent definition of the ID table is missing
in your system.xconf

In the first case you know what you to do: execute it. In the second
case look into the system.xconf of your app and search for something
that resembles a persistent definition for the ID table. If you don't
find it then you know why you get the error.

Will think more... maybe I'll have a better idea...

Cheers,

Aleks

On Fri, 2004-07-02 at 18:40, Maurizio Brilli wrote:
> 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
> _______________________________________________
> User mailing list
> [email protected]
> http://lists.keelframework.org/listinfo.cgi/user-keelframework.org
>