Torque doesn't work in Japanese

[Karl Stenerud <ka...@webartjapan.com>]

I'm having problems trying to get Torque to run under a Japanese environment.
If I set my locale to en_US, everything works fine.
As soon as I set the locale to ja_JP or ja_JP.euc (by setting the LANG 
environment variable under Linux), it throws an exception when I try to add 
an entry to the database.

Example:

try {
    data.torque.Adminuser dso = new data.torque.Adminuser();
    dso.setUsername("12345");
    dso.setPassword("67890");
    dso.save();
} catch(Exception exc) {
    CommonLogContext.logException("AdminUserDataModel.addAdminUser()", exc);
}


Exception if I use the native ID generator (defaultIdMethod="native"):

Exception in AdminUserDataModel.addAdminUser(): 
[org.apache.torque.TorqueException: Column name: PASSWORD does not exist!]
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:729)
data.torque.BaseAdminuserPeer.doInsert(BaseAdminuserPeer.java:216)
data.torque.BaseAdminuserPeer.doInsert(BaseAdminuserPeer.java:565)
data.torque.BaseAdminuser.save(BaseAdminuser.java:313)
data.torque.BaseAdminuser.save(BaseAdminuser.java:275)
data.torque.BaseAdminuser.save(BaseAdminuser.java:255)
data.AdminUserDataModel.addAdminUser(AdminUserDataModel.java:73)
...


Exception if I use the IDBroker (defaultIdMethod="idbroker"):

Exception in AdminUserDataModel.addAdminUser(): 
[org.apache.torque.TorqueException: For input string: "qppp"]
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:713)
data.torque.BaseAdminuserPeer.doInsert(BaseAdminuserPeer.java:216)
data.torque.BaseAdminuserPeer.doInsert(BaseAdminuserPeer.java:565)
data.torque.BaseAdminuser.save(BaseAdminuser.java:313)
data.torque.BaseAdminuser.save(BaseAdminuser.java:275)
data.torque.BaseAdminuser.save(BaseAdminuser.java:255)
data.AdminUserDataModel.addAdminUser(AdminUserDataModel.java:73)
...

I'm using Torque 3.0, Struts 1.0.2, and running it under Tomcat 4.1.18.

Re: Torque doesn't work in Japanese

[Karl Stenerud <ka...@webartjapan.com>]

Never mind.. it was because I had to specify:

jdbc:mysql://127.0.0.1/myproject?useUnicode=true&characterEncoding=EUC_JP

instead of:

jdbc:mysql://127.0.0.1/myproject

in Torque.properties.


Mind you, the error messages were far from helpful =(

Help: datadump task failed

[Dongsheng Song <eg...@msn.com>]

When I use Torque 3.0, Oracle jdbc 8.1.7.1, run datadump task, failed with the following message:

d:\usr\ant\bin\ant -debug -f build-torque.xml datadump

...
BUILD FAILED
file:D:/usr/torque/build-torque.xml:444: Exception thrown by 'tableTool.fetch'.
For more information consult the velocity log, or invoke ant with the -debug flag.
        at org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:564)
        at org.apache.tools.ant.Task.perform(Task.java:319)
        at org.apache.tools.ant.Target.execute(Target.java:309)
        at org.apache.tools.ant.Target.performTasks(Target.java:336)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1250)
        at org.apache.tools.ant.Main.runBuild(Main.java:610)
        at org.apache.tools.ant.Main.start(Main.java:196)
        at org.apache.tools.ant.Main.main(Main.java:235)
Caused by: java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
        at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
        at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
        at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
...