Skip to main content

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:

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)
(another nullpointerexception followed code, expects database).

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

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

After Effect warning: A problem occurred when processing OpenGL commands

Preconditions Failed. - Joomla! Forum - community, help and support