Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Paradox
Question about a query
Picavet
2007-03-08 12:07:11.0
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.0
>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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
Failed still to access http://www.imeria.fr/telecharger/projet.zip .

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap