[peterj]

The '&' vs '& a m p ;' is a non-issue. I have it spelled out just like you, it appears that either the code tag or the browser replaced '& a m p ;' with siimply &.

Regarding whether you should be using utf-8, did you read the link I provided?

My default character set is latin1.

[andrewboyd]

Peter,
I just finished the article that you provided a link to. It looks like I should switch to latin1 ( at least for keys). I'm planning to use utf-8 eventually but if I can't get the app up I won't be using anything. :-(

Do I need to drop the DB and re-create with latin1 or do you know how to change?

I would like to thank you again for all of you help.

Andrew

[andrewboyd]

Peter you are the BOMB! I switched from utf-8 to latin1 and everything went as it should.

I'm thinking that I should open up a bug on jboss portal. It was all because a key used in the jbp_instance_per_user table was over 1000 bytes.

Thanks again for all of your help!

Andrew

[nhatnam]

Hi Peter,

If Hibernate create database successfully and smoothly, will the users (admin,user,etc.) be created in the table JBP_USERS ?
When i first run Jboss, the database with tables were created but the recordset of some tables such as JBP_USER, JBP_ROLES were all empty. Why?

THankyou

[peterj]

Did you read all of the posts in this thread? The answer is in there. ;-)

[ewernli]

The following worked for me:
1) change the datasource according to the previous post:

<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>

but use the html entity instead for the & symbol, otherwise you will get error in your log saying that the datasource could not be loaded.

2) turn mysql in strict mode according to the previous post
3) delete default/log, default/data, default/tmp
4) clean your database (remove all tables) from the the unsucessfull install
5) use the proper driver: com.mysql.jdbc.Driver and not org.gjt.mm.mysql.Driver