« Return to Thread: Mysql migration problems

Mysql migration problems

by Stephen Eaton :: Rate this Message:

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

« Return to Thread: Mysql migration problems