« Return to Thread: Mysql migration problems

Re: Mysql migration problems

by ptrthomas :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi,

I ran into this exact same problem today (coincidence!) when migrating another Java app from windows to linux at work. We found this link which saved the day:

http://confluence.atlassian.com/display/KB/CSP-13667+-+java.sql.SQLException++Table+%27confluence.BANDANA%27+doesn%27t+exist

I think the simplest solution is to switch your MySQL database to case-insensitive, here is the link the above knowledge-base article points to:

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Thanks,

Peter.

On 4/2/08, Stephen Eaton <seaton@...> wrote:

I'm trying to migrate my existing JTRAC installation, the current stable release of jtrac using HQDB on a win2003 server, to mysql running on a seperate linux server.

I have made the changes the jtrac.properties connector and restarted jtrac, jtrac successfully connects to mysql and creates the missing tables, however the migration script bombs out with the following errors:

D:\jtrac\data\db>java -cp bsh-2.0b4.jar;hsqldb-1.8.0.1.jar;mysql-connector-java-
5.1.6-bin.jar bsh.Interpreter jtrac-hsqldb-to-mysql.bsh
insert into ATTACHMENTS (ID, PREVIOUS_ID, FILE_NAME, FILE_PREFIX, ITEM_ID) value
s (?, ?, ?, ?, ?)
Script threw exception: Sourced file: jtrac-hsqldb-to-mysql.bsh : Method Invocat
ion stmt2.execute : at Line: 48 : in file: jtrac-hsqldb-to-mysql.bsh : stmt2 .ex
ecute ( )

Target exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
le 'jtrac.ATTACHMENTS' doesn't exist

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jtrac.ATTACHME
NTS' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

What looks like the problem are the table names that jtrac created within mysql are all in lowercase, not uppercase that the script seems to show and so does not see them.

Stephen...

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
j-trac-users mailing list
j-trac-users@...
https://lists.sourceforge.net/lists/listinfo/j-trac-users

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
j-trac-users mailing list
j-trac-users@...
https://lists.sourceforge.net/lists/listinfo/j-trac-users

« Return to Thread: Mysql migration problems