Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gdiffor

    java.sql.SQLException: Communication link failure:

    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
  2. gdiffor

    protocol version?

    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?
  3. gdiffor

    Simple SQL Query Problem?

    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...
  4. gdiffor

    JDBC error connecting to MySQL

    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
  5. gdiffor

    executeUpdate() java method & MySQL

    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...
  6. gdiffor

    Will someone please help me with this code. : )

    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
  7. gdiffor

    advance mouse cursor to text box

    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...
  8. gdiffor

    How to select * from mytable where &lt;ANY FIELD&gt; = something

    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...
  9. gdiffor

    Can anyone tell correct my followin

    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...
  10. gdiffor

    Java executeUpdate() method with MySQL

    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...
  11. gdiffor

    Java executeUpdate() method with MySQL

    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...

Part and Inventory Search

Back
Top