-
1. Re: SEAM JEE5 Example w/MySQL Question
nwhite Jul 17, 2007 11:14 PM (in response to nwhite)Well, when I said that was the last entry in the app server log I was mistaken. Looks like the buffer hadn't flushed in my tail. Applogies, here is a sample of the problem in the logs -
[#|2007-07-17T22:24:05.970-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:05,970 INFO [SettingsFactory] Default entity-mode: pojo
|#]
[#|2007-07-17T22:24:06.010-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,010 INFO [SessionFactoryImpl] building session factory
|#]
[#|2007-07-17T22:24:06.490-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,490 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
|#]
[#|2007-07-17T22:24:06.510-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,510 INFO [SchemaExport] Running hbm2ddl schema export
|#]
[#|2007-07-17T22:24:06.510-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,510 INFO [SchemaExport] exporting generated schema to database
|#]
[#|2007-07-17T22:24:06.551-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,541 ERROR [SchemaExport] Unsuccessful: create table Booking (id bigint not null auto_increment, checkinDate date not null, checkoutDate date not null, creditCard varchar(16) not null, smoking bit not null, beds integer not null, creditCardName varchar(70) not null, creditCardExpiryMonth integer not null, creditCardExpiryYear integer not null, user_username varchar(15) not null, hotel_id bigint not null, primary key (id)) ENGINE=InnoDB
|#]
[#|2007-07-17T22:24:06.551-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|22:24:06,551 ERROR [SchemaExport] No database selected
|#] -
2. Re: SEAM JEE5 Example w/MySQL Question
nwhite Jul 18, 2007 3:16 PM (in response to nwhite)FWIW I got the DB tables to create and load the sql by changing the Resource Type on my pool from javax.sql.ConnectionPoolDataSource to javax.sql.DataSource and leaving the Datasource Classname set to com.mysql.jdbc2.optional.MysqlConnectionPoolDataSource.
Any thoughts on why this is what it took? And the error msg. did not really lend any relevant suggestion as to this change being the fix.