java.sql.SQLException:

HI All,

I am getting the following exception while using mysql with java:

java.sql.SQLException: Error writing file '/var/log/mysql.log' (Errcode: 28)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)

at com.redalkemi.pdge.threads.HypersonicRegeneratorThread1.run(HypersonicRegeneratorThread1.java:116)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)

at java.lang.Thread.run(Thread.java:619)

Exception in thread "main" java.sql.SQLException: Column 'vchCatSubcatSynmName' not found.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)

at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:955)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5436)

at com.redalkemi.pdge.crons.HypersonicRegenerator.regenerateMainCatPage(HypersonicRegenerator.java:1428)

at com.redalkemi.pdge.crons.HypersonicRegenerator.regenerateProject(HypersonicRegenerator.java:318)

at com.redalkemi.pdge.crons.HypersonicRegenerator.main(HypersonicRegenerator.java:171)

java.sql.SQLException: Error writing file '/var/log/mysql.log' (Errcode: 28)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)

at com.redalkemi.pdge.threads.HypersonicRegeneratorThread1.run(HypersonicRegeneratorThread1.java:108)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)

at java.lang.Thread.run(Thread.java:619)

I could not understand why it is coming.

[2549 byte] By [Nistelrooya] at [2007-11-27 4:32:41]
# 1
Exception in thread "main" java.sql.SQLException: Column 'vchCatSubcatSynmName' not found.you try to reach a column that does not exist
calvino_inda at 2007-7-12 9:42:25 > top of Java-index,Java Essentials,Java Programming...
# 2
From the stacktrace I would assume that there are two issues here:1) Mysql does not have permission to append to the log file /var/log/mysql.logand 2) It can't identify the column vchCatSubcatSynmName
ChristopherAngela at 2007-7-12 9:42:25 > top of Java-index,Java Essentials,Java Programming...
# 3
> 1) Mysql does not have permission to append to the log file /var/log/mysql.log1a) Disk is full so /var/log/mysql.log can't be written
quittea at 2007-7-12 9:42:25 > top of Java-index,Java Essentials,Java Programming...
# 4
Thanks my friend ... it was the problem of space not left on system
Nistelrooya at 2007-7-12 9:42:25 > top of Java-index,Java Essentials,Java Programming...