Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: "Bullard, Jeffrey W. Dr." <jeffrey.bullard@nist.gov>
To: "ddlutils-user@db.apache.org" <ddlutils-user@db.apache.org>
Date: Wed, 13 Jan 2010 17:06:19 -0500
Subject: Re: newbie can't connect to/export from MySQL with ant task
Thread-Topic: newbie can't connect to/export from MySQL with ant task
Thread-Index: AcqUkflvN3p00OIWSAabFgotevHhRAACqi7I
Message-ID: <C773AE0B.CF4%jeffrey.bullard@nist.gov>
In-Reply-To: <224f32341001131248k56824865sed42c8700821d954@mail.gmail.com>
Accept-Language: en-US
Content-Language: en
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_C773AE0BCF4jeffreybullardnistgov_"
MIME-Version: 1.0

--_000_C773AE0BCF4jeffreybullardnistgov_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Thanks, Tom, that was a big help, and now the problem seems to be solved.  =
Here's what I did:
I installed SquirrelSQL and tried to connect to the same MySQL database, an=
d I received the following error when I tried to specify the com.mysql.jdbc=
.Driver driver:

Could not find class com.mysql.jdbc.Driver in neither the Java class path n=
or the Extra class path of the MySQL Driver driver definition:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

So the driver wasn't found, which led me to suspect that the mysql-connecto=
r-java-3.1.12-bin.jar was not in my CLASSPATH.  So I added it to my CLASSPA=
TH and now everything seems to be working fine.  Not really a DdlUtils issu=
e after all, but you really helped me out.  Thanks again.

Jeff

On 1/13/10 3:48 PM, "Thomas Dudziak" <tomdzk@gmail.com> wrote:

Since Ddlutils doesn't do anything unusual as far as JDBC is
concerned, could you try to connect with that connection information
and the same driver jar, e.g. by using SquirrelSQL or something
similar (but Java/JDBC based) ?

Tom

On Wed, Jan 13, 2010 at 12:45, Jeffrey W. Bullard
<jeffrey.bullard@nist.gov> wrote:
> I added the verbosity parameter to the task like this in the build.xml fi=
le:
>
> <databaseToDdl modelName=3D"MigrateTest" verbosity=3D"debug">
>    <database url=3D"jdbc:mysql://localhost:3306/vcctl_user"
>        driverClassName=3D"com.mysql.jdbc.Driver"
>        username=3D"root"
>        password=3D"vcctl7"/>
>
>    <writeSchemaToFile outputFile=3D"db-schema.xml"/>
>    <writeDataToFile outputFile=3D"data.xml"/>
> </databaseToDdl>
>
> but the output to stdout is exactly the same as before.  Is there a log f=
ile
> somewhere that I should be checking?
>
> Jeff
>
> On Jan 13, 2010, at 3:29 PM, Thomas Dudziak wrote:
>
>> Could you increase the verbosity of the task (see
>>
>> http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.DatabaseToDdl=
Task.html)
>> to debug to get more detail logging, and post that here ?
>>
>> Tom
>>
>> On Wed, Jan 13, 2010 at 11:20, Jeffrey W. Bullard
>> <jeffrey.bullard@nist.gov> wrote:
>>>
>>> Hi,
>>>
>>> I'm trying to export a MySQL database using DdlUtils.  I went through a
>>> tutorial (http://db.apache.org/derby/integrate/db_ddlutils.html) that
>>> showed
>>> how to export a derby DB and I'm trying to modify the build.xml file to
>>> do
>>> the same thing for a MySQL database on my local machine.  The build.xml
>>> file
>>> is copied below.
>>>
>>> When I run "ant export-source-db", I get the following error:
>>>
>>> BUILD FAILED
>>> build.xml:16: Could not read the schema from the specified database:
>>> Could
>>> not get a connection from the datasource
>>>
>>> I have no doubt that my line 16 is wrong, but I cannot find any
>>> information
>>> about the correct format for connecting to a MySQL database.  The full
>>> path
>>> to the database on my machine is /usr/local/mysql/data/vcctl_user
>>>
>>> Other information:  My mysql server is definitely running on the machin=
e,
>>> and the vcctl_user database can be accessed from within mysql from the
>>> command line (show tables, etc.).
>>>
>>> Thanks in advance for any help about how I can properly connect to MySQ=
L
>>> database.
>>>
>>> <?xml version=3D"1.0"?>
>>> <project name=3D"MigrateToDerby" basedir=3D".">
>>>
>>>  <path id=3D"classpath">
>>>     <fileset dir=3D"./lib">
>>>        <include name=3D"**/*.jar"/>
>>>     </fileset>
>>>  </path>
>>>
>>>  <target name=3D"export-source-db" description=3D"Dumps db structure an=
d
>>> data">
>>>     <taskdef name=3D"databaseToDdl"
>>>             classname=3D"org.apache.ddlutils.task.DatabaseToDdlTask">
>>>        <classpath refid=3D"classpath"/>
>>>     </taskdef>
>>>
>>>     <databaseToDdl modelName=3D"MigrateTest">
>>>         <database url=3D"jdbc:mysql://localhost:3306/vcctl_user"
>>>                driverClassName=3D"com.mysql.jdbc.Driver"
>>>                username=3D"root"
>>>                password=3D"vcctl7"/>
>>>
>>>        <writeSchemaToFile outputFile=3D"db-schema.xml"/>
>>>        <writeDataToFile outputFile=3D"data.xml"/>
>>>     </databaseToDdl>
>>>
>>>  </target>
>>> </project>
>>>
>>>
>
>


--_000_C773AE0BCF4jeffreybullardnistgov_--