Peter,
I want to thank you for taking the time to help! I compaired your ds-xml to mine and
they look the same. here is mine:
| <?xml version="1.0" encoding="UTF-8"?>
| <datasources>
| <local-tx-datasource>
| <jndi-name>PortalDS</jndi-name>
|
<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>portalUser</user-name>
| <password>portalUser</password>
| </local-tx-datasource>
| </datasources>
|
anonymous wrote : The 'table not found' error is expected the first time you run
the portal with a new database. Hibernate creates the table automatically.
|
I was aware that some errors happened with the initial startup but I've seen this one
before. I just rebooted and here are the errors during startup:
| INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
| ERROR [LocaleUtils] Locale name null or empty, ignoring
|
| ... snip ...
|
| WARN [EhCacheProvider] Could not find configuration
[org.hibernate.cache.UpdateTimestampsCache]; using defaults.
| INFO [StandardQueryCache] starting query cache at region:
org.hibernate.cache.StandardQueryCache
| WARN [EhCacheProvider] Could not find configuration
[org.hibernate.cache.StandardQueryCache]; using defaults.
| WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
| ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_instance_per_user'
doesn't exist
| INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
|
...snip...
| 17:14:22,593 ERROR [SchemaUpdate] Unsuccessful: create table JBP_INSTANCE_PER_USER (PK
bigint not null auto_increment, INSTANCE_PK bigint, SER_STATE longblob, USER_ID
varchar(170) not null, PORTLET_RE
| F varchar(170) not null, primary key (PK), unique (USER_ID, PORTLET_REF))
| 17:14:22,593 ERROR [SchemaUpdate] Specified key was too long; max key length is 1000
bytes
| 17:14:22,609 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_INSTANCE_PER_USER add
index FK9349B3D05EE4E4AE (INSTANCE_PK), add constraint FK9349B3D05EE4E4AE foreign key
(INSTANCE_PK) references JBP
| _INSTANCE (PK)
| 17:14:22,609 ERROR [SchemaUpdate] Table 'jbossportal.jbp_instance_per_user'
doesn't exist
| 17:14:22,609 INFO [SchemaUpdate] schema update complete
|
Do you think I should go ahead and drop the database and re-create as you show above? I
don't have any data. Perhaps since I don't have the hybernate -ds.xml there
anymore it will treate it as the initial startup and will create everyting for me.
Thanks again,
Andrew
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967939#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...