User Profile

Collapse

Profile Sidebar

Collapse
WilHob
WilHob
Last Activity: Jun 1 '07, 03:19 PM
Joined: May 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • WilHob
    replied to Weird error with query
    Hello, Miller:
    Thanks for reply.
    I know in general about Interpolate and placeholder but never used it in practice.
    I know sintax INSERT operator and used it many times with DBMSs
    (Oracle, Foxpro and others) and never had any problems. If it really necessarily to interpolate string, how it practically to do?
    Thanks...
    See more | Go to post

    Leave a comment:


  • WilHob
    started a topic Weird error with query

    Weird error with query

    Hello:
    I executed many times queries in various DBMS but got such error when I started
    to work with MySQL. I run simple query from Java in NetBeans:
    ...
    string s1;
    s1="abc";
    ...
    stmt.executeUpd ate("INSERT INTO Table(F1) VALUES(s1)");
    ...
    I got this error message:

    SQLException: Unknown column 's1' in 'field list'
    ...
    What is wrong???
    See more | Go to post

  • WilHob
    started a topic How to make connection from Java to MySQL?
    in Java

    How to make connection from Java to MySQL?

    Hello:
    I can not make connection to MySQL from Java.

    I set System Variable CLASSPATH to:
    C:\MySQL\mysql-connector-java-5.0.5\mysql-connector-java-5.0.5-bin.jar
    ...
    Then registered Driver:
    ...
    try {
    Class.forName(" com.mysql.jdbc. Driver").newIns tance();
    }
    ...
    Made Connection:
    Connection conn =
    DriverManager.g etConnection("j dbc:mysql://localhost:3306/test","User","P sw");...
    See more | Go to post

  • WilHob
    started a topic Java with MySQL
    in Java

    Java with MySQL

    Hello frieds,
    What is good manual for programming with Java using MySQL and NetBeans (or without NetBeans) (preferably on Internet)?
    Thanks.
    WilHob
    See more | Go to post

  • WilHob
    started a topic Programming Java with MySQL
    in Java

    Programming Java with MySQL

    Hello frieds,
    What is good manual for programming with Java using MySQL (preferably on Internet)?
    Thanks.
    WilHob
    See more | Go to post
No activity results to display
Show More
Working...