Win a copy of Modern JavaScript for the Impatient this week in the Server-Side JavaScript and NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

JBM-Tables not created.

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm using JBoss 4.3.0 and recently switched the defaultDS to mysql. I'm now stuck with an error which is the following. It's the 1st error in the logfile.


I configured to create the tables on every startup like this in deploy/jboss-messaging.sar/mysql-persistence-service.xml


I can see that this config is used when I take a look at the server debug log output:


But still,the table is not there. In fact. the schema does not contain any table.
The Datasource looks like this:


Any Ideas?
 
Stefan Müller
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually, I just found an error in a debug message saying:



But what can I do about it?
 
author
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you running the 'all' or 'default' config? If default, change this line in mysql-persistence-service.xml:

I think that by default it shows up as true, and you need to set it to false.

Also, these steps might help. I know they are for AS 5.0.1, but EAP 4.3 also uses JBoss Messaging so the messaging-related changes are very similar:
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4224936#4224936
 
and POOF! You're gone! But look, this tiny ad is still here:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic