Thread: SQLException (errno: 150) in Ubuntu but not in Windows Vista
hi all. i'm making jdbc-driven application , runs fine in windows not in ubuntu. ubuntu error message goes:
(another nullpointerexception followed code, expects database).code:java.sql.sqlexception: can't create table 'dbname.timelogs' (errno: 150) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1073) at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3597) at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3529) at com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1990) at com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2151) at com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2619) at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1698) at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1617) at net.skytreader.kode.utils.databasedriver.createtablesstructures(databasedriver.java:119) at net.skytreader.kode.utils.databasedriver.<init>(databasedriver.java:65) at net.skytreader.kode.tasktimer.tasktimerrunnable.createdatabase(tasktimerrunnable.java:157) at net.skytreader.kode.tasktimer.tasktimerrunnable.run(tasktimerrunnable.java:92) at java.awt.event.invocationevent.dispatch(invocationevent.java:226) at java.awt.eventqueue.dispatcheventimpl(eventqueue.java:647) at java.awt.eventqueue.access$000(eventqueue.java:96) at java.awt.eventqueue$1.run(eventqueue.java:608) at java.awt.eventqueue$1.run(eventqueue.java:606) at java.security.accesscontroller.doprivileged(native method) at java.security.accesscontrolcontext$1.dointersectionprivilege(accesscontrolcontext.java:105) at java.awt.eventqueue.dispatchevent(eventqueue.java:617) at java.awt.eventdispatchthread.pumponeeventforfilters(eventdispatchthread.java:275) at java.awt.eventdispatchthread.pumpeventsforfilter(eventdispatchthread.java:200) at java.awt.eventdispatchthread.pumpeventsforhierarchy(eventdispatchthread.java:190) at java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:185) at java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:177) at java.awt.eventdispatchthread.run(eventdispatchthread.java:138)
read here because myisam doesn't support foreign key constraints , yes using foreign key constraints. however, works fine in vista. so....?
set-up wise, difference can think of xampp server running. i'm running 1.7.3 in vista while ubuntu runs 1.7.4 . unless mistaken, that's not supposed matter, right?
*bump*
Forum The Ubuntu Forum Community Ubuntu Specialised Support Development & Programming Programming Talk [SOLVED] SQLException (errno: 150) in Ubuntu but not in Windows Vista
Ubuntu
Comments
Post a Comment