Question about a query |
Picavet |
2007-03-08 12:07:11 |
is it normal with the demo version of this program i can't do a select with a clause "where" like that? i have a mistake ...it was for trying before to buy it .
like that :
ResultSet rs = stmt.executeQuery("SELECT * FROM personne WHERE id='1' ");
while (rs.next()) {
Personne p = new Personne();
p.setId(rs.getInt("id"));
p.setNom(rs.getString("nom"));
p.setPrenom(rs.getString("prenom"));
p.setAdresse(rs.getString("adresse"));
al.add(p);
System.out.println(
rs.getInt("id")
+ " | "
+ rs.getString("nom")
+ " | "
+ rs.getString("prenom")
+ " | "
+ rs.getString("adresse"));
error :
java.sql.SQLException: Can't parse SELECT * FROM personne WHERE id = 1!:
java.lang.NoSuchMethodError: java/util/Date.(III)V
at com.hxtt.sql.common.q.(Unknown Source)
at java.lang.Class.initializeImpl(Native Method)
at java.lang.Class.initialize(Class.java:350)
thx to help me :) it work when i cut the "where id ="1" ; thx
|
Re:Question about a query |
HXTT Support |
2007-03-08 16:19:20 |
>java.lang.NoSuchMethodError: java/util/Date.(III)V
What's your Java VM version? It seems that your JDK is J2ME?
|
Re:Re:Question about a query |
Picavet |
2007-03-08 16:46:54 |
so the request works and i've a result when i haven't got clause " where ..." , but when i add it i have this mistake .
I have J2ME with the VM J9 of IBM
i have try with a preparedstatement and it's the same mistake . So i don't know what i must do . Thx for the reply
|
Re:Re:Question about a query |
Picavet |
2007-03-08 16:49:23 |
so the request works and i've a result when i haven't got clause " where ..." , but when i add it i have this mistake .
I have J2ME with the VM J9 of IBM
i have try with a preparedstatement and it's the same mistake . So i don't know what i must do . Thx for the reply
|
Re:Re:Re:Re:Question about a query |
HXTT Support |
2007-03-08 16:58:54 |
|
Because J2ME hasn't some necessary class or method. You can try HXTT Paradox JDBC1.2 package.
|
Re:Re:Re:Re:Re:Question about a query |
Picavet |
2007-03-08 17:29:43 |
i have add HXTT Paradox JDBC1.2 package to my project and same error when i add the clause :/
java.sql.SQLException: Can't parse select * from personne where id='1'!:
java.lang.NoSuchMethodError: java/util/Date.(III)V
at com.hxtt.sql.common.c.(Unknown Source)
at java.lang.Class.initializeImpl(Native Method)
at java.lang.Class.initialize(Class.java:350)
at com.hxtt.d.j.a(Unknown Source)
at com.hxtt.sql.bt.a(Unknown Source)
at com.hxtt.sql.bt.a(Unknown Source)
at com.hxtt.sql.e.a(Unknown Source)
at com.hxtt.a.a.goto(Unknown Source)
at com.hxtt.sql.c3.l(Unknown Source)
at com.hxtt.sql.al.a(Unknown Source)
at com.hxtt.sql.al.a(Unknown Source)
at com.hxtt.sql.al.executeQuery(Unknown Source)
at Principale.main(Principale.java:62)
|
Re:Re:Re:Re:Re:Re:Question about a query |
Picavet |
2007-03-08 17:31:12 |
Statement stmt = con.createStatement();
String sql = "select * from personne ";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
String gencoduv = rs.getString("nom");
String refproduit = rs.getString("prenom");
System.out.println(refproduit);
this request works and i have just add where id = 1 ... and Blackout :/
|
Re:Re:Re:Re:Re:Re:Re:Question about a query |
HXTT Support |
2007-03-08 17:38:04 |
|
Then it means that your J2ME has called some unsupported method. Let us know your Java detailed environment, and we will try to see whether we can provide a package 4 J2ME.
|
Re:Re:Re:Re:Re:Re:Re:Re:Question about a query |
Picavet |
2007-03-08 18:24:33 |
thx for the replies so quickly :)
hi, the specifications.
used technologies :
Java with IBM® WebSphere Studio Device Developer 5.7
we are developing for a pocket pc who works in windows C.E 5.0 and so we use virtual machine of ibm J9 dedicated for it.
you can download it on this url with all used classes : www.imeria.fr/telecharger/ppro10.rar
and the exemple who i try to do on this archive : www.imeria.fr/telecharger/ppro10.rar
|
Re:Re:Re:Re:Re:Re:Re:Re:Question about a query |
Picavet |
2007-03-08 18:26:30 |
the exemple on this url sorry : www.imeria.fr/telecharger/projet.zip
thx for all
|
Re:Re:Re:Re:Re:Re:Re:Re:Question about a query |
Picavet |
2007-03-08 18:28:22 |
the exemple on this url sorry : www.imeria.fr/telecharger/projet.zip
thx for all
|
Re:Re:Re:Re:Re:Re:Re:Re:Question about a query |
HXTT Support |
2007-03-12 18:38:53 |
|
Failed still to access http://www.imeria.fr/telecharger/projet.zip .
|
Main
webmaster@hxtt.com