Search results for query: *

Has anyone seen this before? java.sql.SQLException: Communication link failure: java.io.IOException at org.gjt.mm.mysql.MysqlIO.init I am trying to connect to a MySql DB (via JDBC) and I am getting this message. I'm running out of things to try. -GD

I'm having a problem connecting to MySQL from JDBC. The error I get seems to be caused by a mismatched protocol version. When I perform mysqladmin with the version option, It displays protocol version 10. Is this something that can be modified?

If the variable - argShowCourse contains the name of a column in your table, you would code the following: String sqlQuery = "SELECT * from modules WHERE " + argShowCourse + " = 'O'"; If the variable - argShowCource contains the value you want to search for, you would code...

I am running a Java application and am trying to access a MySQL database. I continue to get the following error: Error occurred... java.sql.SQLException: Server configuration denies access to data source It seems to be knocking me down before it does any user authentication. Any ideas? -GD

I am using Java's JDBC API to talk to MySQL. I need to invoke the executeUpdate(String query, int getGeneratedKeys) method of the Statement class. I need this because I need to insert a record and have the database return the value for the auto_incremented key field. I have been unable to find...

I believe also that the switch statement only works with an integer in the (). At least this is how it works in Java. You may need to write a nested if/else

starway is on the right track: Try this: <form name=form1> <input type=&quot;text&quot; id=&quot;one&quot; onKeyDown=&quot;moveFocus(this, two)&quot;> <input type=&quot;text&quot; id=&quot;two&quot; onKeyDown=&quot;moveFocus(this, three)&quot;> <input type=&quot;text&quot...

One way to ease your life when writing SQL is to put it in a file instead of typing it in at the command line. You can access the file with the \. command. This way, if you use one type of SQL statement often, you can just modify an existing query instead of retyping the whole thing every...

Is it true that you're MySQL as your database of choice? If so, MySQL doesn't support subQueries (at least not yet) You could run your subquery portion first. Get the string(s) from your result set and place them in a Vector. Next execute your outer query by building a comma separated list of...

I am using Java's JDBC API to talk to MySQL. I need to invoke the executeUpdate(String query, int getGeneratedKeys) method of the Statement class. I need this because I need to insert a record and have the database return the value for the auto_incremented key field. I have been unable to find...

I am using Java's JDBC API to talk to MySQL. I need to use the version of the executeUpdate() method of the Statement class which allows the driver to return auto generated key values. MySQL doesn't seem to support this feature. I'm wondering if anyone has experienced the same and if there is...