RE: [Modelj-user] Re: Setting up jboss & mysql

[Tom T. <tom...@ho...>]

Your <connection-url> and <driver-class> should look like:

    
<connection-url>jdbc:mysql://localhost/DB_NAME?autoReconnect=true</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>

The generated code doesn't itself create the database tables, but once you 
deploy the .ear file the database tables will be created (if they do not 
exist).

Tom

>From: Neil Earnshaw <ne...@os...>
>To: mod...@li...
>Subject: [Modelj-user] Re: Setting up jboss & mysql
>Date: Fri, 30 Jan 2004 23:00:40 +0000
>MIME-Version: 1.0 (Apple Message framework v609)
>Received: from sc8-sf-list1.sourceforge.net ([66.35.250.206]) by 
>mc11-f12.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Fri, 30 Jan 
>2004 15:04:23 -0800
>Received: from localhost ([127.0.0.1] helo=projects.sourceforge.net)by 
>sc8-sf-list1.sourceforge.net with esmtp (Exim 4.30)id 1Amhed-0003kf-AT; 
>Fri, 30 Jan 2004 15:02:27 -0800
>Received: from sc8-sf-mx1-b.sourceforge.net ([10.3.1.11] 
>helo=sc8-sf-mx1.sourceforge.net)by sc8-sf-list1.sourceforge.net with esmtp 
>(Exim 4.30)id 1AmhYn-0001c0-Fdfor mod...@li...; Fri, 
>30 Jan 2004 14:56:25 -0800
>Received: from mercury0.easily.co.uk ([213.161.76.90] helo=easily.co.uk)by 
>sc8-sf-mx1.sourceforge.net with esmtp (Exim 4.30)id 1AmhYm-0007H0-Jifor 
>mod...@li...; Fri, 30 Jan 2004 14:56:24 -0800
>Received: from [213.160.109.105] (account rk3zalsq4z32 HELO [192.168.1.33]) 
>  by easily.co.uk (CommuniGate Pro SMTP 4.1.3)  with ESMTP id 45626962 for 
>mod...@li...; Fri, 30 Jan 2004 22:56:14 +0000
>X-Message-Info: JGTYoYF78jEjEOX1Xlj8yuJaR4vNiOMo
>Message-Id: <1FE...@os...>
>X-Mailer: Apple Mail (2.609)
>X-Spam-Score: 0.0 (/)
>X-Spam-Report: Spam Filtering performed by sourceforge.net.See 
>http://spamassassin.org/tag/ for more details.Report problems to 
>http://sf.net/tracker/?func=add&group_id=1&atid=200001
>Errors-To: mod...@li...
>X-BeenThere: mod...@li...
>X-Mailman-Version: 2.0.9-sf.net
>Precedence: bulk
>List-Unsubscribe: 
><https://lists.sourceforge.net/lists/listinfo/modelj-user>,<mailto:mod...@li...?subject=unsubscribe>
>List-Id: <modelj-user.lists.sourceforge.net>
>List-Post: <mailto:mod...@li...>
>List-Help: <mailto:mod...@li...?subject=help>
>List-Subscribe: 
><https://lists.sourceforge.net/lists/listinfo/modelj-user>,<mailto:mod...@li...?subject=subscribe>
>List-Archive: 
><http://sourceforge.net/mailarchive/forum.php?forum=modelj-user>
>Return-Path: mod...@li...
>X-OriginalArrivalTime: 30 Jan 2004 23:04:23.0970 (UTC) 
>FILETIME=[66E8B820:01C3E785]
>
>I found mysql-ds.xml and dragged it into 
>/usr/local/jboss/server/default/deploy/mysql-ds.xml
>
>Judging by the activity in the JBoss term it was quite happy with it, but 
>there was no change in the web front end.
>
>mysql-ds.xml contains this line
>
>     <connection-url>jdbc:mysql://dell:3306/jbossdb</connection-url>
>
>which I find a bit suspect, as I'm on a Mac, not a Dell box.  Or does dell 
>signify something else?
>
>Does the generated code create a mysql database and tables?
>
>I have verified that mysql is running, but I had to 'sudo mysql' before I 
>could create a database.  Could it be that the it's a permission thing 
>that's stopping the database being created, or do I need to set it up 
>manually.
>
>I feel really uncomfortable, ignorantly poking things to see what happens.  
>Are there any good references on-line for setting up JBoss?  I've got to 
>demo a quick and nasty UML to J2EE by Tuesday so I don't have time to wait 
>for Amazon to deliver.  I've done loads of code generation from models, but 
>I'm a complete starter in the J2EE world.
>
>Any help greatly appreciated.
>
>-Neil
>
>--
>
>Neil Earnshaw
>Consultant Software Engineer
>Object Software Engineers Ltd
>ne...@os...
>Tel  : 01747 850 676
>Mbl : 07793 084 161

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca