Re: Compiling with mysql

Andrew, i dont understand what do you mean with exactly, I will try to
explain again, i isolated the problem only compiling a short code that only
conects to the database and exit. 

1) The code is the following

import java.sql.*;

public class MysqlConnect{
  public static void main(String[] args) {
    System.out.println("MySQL Connect Example.");
    Connection conn = null;
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "myDatabase";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "root";
    try {
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      System.out.println("Connected to the database");
      conn.close();
      System.out.println("Disconnected from database");
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

2) I compile
gcj --main=MysqlConnect -o mysqlconnect MysqlConnect.java

(gcj version : 4.3.1)

3) Execution:

./mysqlconnect

4) Output:

MySQL Connect Example.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '????????????????????????????????'
at line 1
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2525)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
   at java.sql.DriverManager.getConnection(libgcj.so.90)
   at java.sql.DriverManager.getConnection(libgcj.so.90)
   at MysqlConnect.main(MysqlConnect.java:14)

5) I installed a previous version of gcj 4.2 and repetead the compilation
and execution, and the result was the following:

MySQL Connect Example.
java.sql.SQLException: Error during query: Unexpected Exception:
java.io.CharConversionException message given: null

Nested Stack Trace:


** BEGIN NESTED EXCEPTION ** 

java.io.CharConversionException

STACKTRACE:

java.io.CharConversionException
   at gnu.gcj.convert.Input_iconv.read(libgcj.so.81)
   at java.lang.String.init(libgcj.so.81)
   at java.lang.String.<init>(libgcj.so.81)
   at
com.mysql.jdbc.SingleByteCharsetConverter.<init>(SingleByteCharsetConverter.java:153)
   at
com.mysql.jdbc.SingleByteCharsetConverter.initCharset(SingleByteCharsetConverter.java:108)
   at
com.mysql.jdbc.SingleByteCharsetConverter.getInstance(SingleByteCharsetConverter.java:86)
   at com.mysql.jdbc.Connection.getCharsetConverter(Connection.java:3505)
   at com.mysql.jdbc.StringUtils.getBytes(StringUtils.java:615)
   at com.mysql.jdbc.Buffer.writeStringNoNull(Buffer.java:655)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1686)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2525)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
   at java.sql.DriverManager.getConnection(libgcj.so.81)
   at java.sql.DriverManager.getConnection(libgcj.so.81)
   at MysqlConnect.main(mysqlconnect)


** END NESTED EXCEPTION **


   at com.mysql.jdbc.Connection.execSQL(Connection.java:3330)
   at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2525)
   at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
   at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
   at java.sql.DriverManager.getConnection(libgcj.so.81)
   at java.sql.DriverManager.getConnection(libgcj.so.81)
   at MysqlConnect.main(mysqlconnect)

6) It seems it cant execute  the line conn =
DriverManager.getConnection(url+dbName,userName,password);
From the same machine executing with java sun, it did well, but not with the
java version from the gcj.. 

It was exactly what i did.. dont know what else could i add.







Andrew Haley wrote:
> 
> ezer wrote:
>> New try:
>> 
>> I generated mysql-connector-java-5.0.8-bin.o
>> and used it in the compilation of the program
>> gcj --main=Search --classpath=mysql-connector-java-5.0.8-bin.o 
>> Searcher.jar
>> -o search
>> 
>> It compiles without errors, but when i execute ./search i get
>> segmentation
>> fault
>> 
>> I dont know what to do.. help please...
> 
> the key problem here is that you haven't told us *exactly* what you are
> doing.  We need to know if we can help you.
> 
> http://www.catb.org/~esr/faqs/smart-questions.html
> 
> Andrew.
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Compiling-with-mysql-tp19092090p19290948.html
Sent from the gcc - java mailing list archive at Nabble.com.