Hibernate cfg, Connector, MySQL problem

[svaret]

Hi,

I want to use MySQL 4.1.8 with my jboss-portal-2.0.1-jboss-4.0.3SP1 installation.

In the hibernate config file located in server\default\deploy\jboss-portal.sar\conf\hibernate I have added the following line:
org.hibernate.dialect.MySQLDialect.

I have placed the jar-file called mysql-connector-java-3.1.12-bin.jar under the directory server\default\lib.

I have placed the file portal-mysql-ds.xml in directory server\default\deploy. The file looks like this:
<?xml version="1.0" encoding="UTF-8"?>

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>portal</user-name>
portalpassword
</local-tx-datasource>
<no-tx-datasource>
<jndi-name>NoTxPortalDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>portal</user-name>
portalpassword
</no-tx-datasource>


Upon starting Jboss AS with Portal bundled I get the confusing log message:
13:37:00,086 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
13:37:00,337 INFO [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0
13:37:00,337 INFO [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0
13:37:00,377 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect

Driver used is HSQL but it has recognized that I am using MySQL.

I then get errors when Database Content is about to be created:
13:37:01,919 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
13:37:01,919 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
13:37:01,919 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
id integer not null auto_increment]
13:37:01,919 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref (jbp_id integer not null auto_incre
ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer, primary key (jbp_id))
13:37:01,919 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref (j
bp_id integer not null auto_increment]
13:37:01,919 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set (jbp_id integer not null auto_i
ncrement, jbp_parent_id integer, name varchar(255) not null, primary key (jbp_id))
13:37:01,919 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref_se
t (jbp_id integer not null auto_increment].

What am I doing wrong? Very grateful for any suggestions.

Best regards

Lasse

[scottdawson]

Lasse,
Delete portal-hsqldb-ds.xml from the deploy directory. That's the default datasource that comes with the bundle.

Regards,
Scott Dawson
Unisys

[noicangi]

scott its right delete de portal hsqldb-ds.xml and add the portal-MYSQL-ds.xml configured to your database and in /server/default/lib copy the mysql connector 3.1.12

[svaret]

Ok thanks and it works now....

But what I think is that when a user guide is written parts that you have to do shouldn't be left out which this was. Nothing in the userguide states that the portal-hsqldb-ds.xml should be removed. Why not write that as well even though it's obvious when you say it.

Best regards
Lasse

[noicangi]

hahaha your right, i'm creating a user guide in spanish about JBoss and i read all the doc's and it seems the ones in charge of the documentation recicle the older ones to fit the new portal and AS.

the user guide doens't guide you installing and configurating Jboss, i tried to install separately and dont work.(maybe a jboss as config on the install).

that's the price and benefits of open source.

[svaret]

Hombre, asi es la vida.

[theute]

The doc build can support multiple language, it would be nice if you could participate in writing the doco (enhance the English one or start the spanish one ;) )

(That's the benefit of Open Source, no price ;) )

[svaret]

The doc build can support multiple language, it would be nice if you could participate in writing the doco (enhance the English one or start the spanish one ;) )

(That's the benefit of Open Source, no price ;) )

Me?

[theute]

Anybody who find bugs in the doco or want to add things, is welcomed to propose a patch through Jira (http://jira.jboss.com/jira/browse/JBPORTAL same username/password as this forum)

To do so you can checkout the documentation in docbook format from the CVS (http://anoncvs.forge.jboss.com/viewrep/JBoss/jboss-portal-docs) and edit the files then create a Jira task attached to the "documentation" component

[noicangi]

ok, i will send you the doc in spanish when i finish it (i'am stuck at the cms because of the bugs), in english will be later because the tecnical language is a little bit difficult ( the apple is red at school its unsignificant).

if you could post some information about developing portlets it would be great, i read all about xml config files but the doc of developing with the jboss eclipse its very old.

i would be glad of cooperate with you about documentation for users(generaly newbies).

[roy.russo]

noicangi,

Send me the spanish doc as well. I am a native Spanish speaker.

Thomas,

You laughed at me 6 months ago, when I proposed the Spanish Doc. Now I laugh at you. ;-)

[theute]

Thank you noicangi :)

What is missing about developing portlets ? Do you mean about developing standard JSR168 portlets or something specific to JBoss Portal ?

[noicangi]

hi thomas, i send an email to roy to develop the first manual about instaling an config in spanish,

yes i mean about developing jsr168 portlets for jboss portal in jboss eclipse, i found a tutorial about this for weblogic work*** but not for jboss. i'm begginning in java and i know C so learn to create a basic portlet in eclipse will be very helpfull to create a spanish doc. and for me :P.


i read the post about eclipse and portlets....i hope it comes soon.