This source run OK in RedHat 7.2 and win2000 ( jdk1.3.1 and sapdb.jar
7.3.0.20)
but the problem is in Suse7.2
Anybody have any idea that could happened ?
Jaime
----- Original Message -----
From: "Jaime21" <[EMAIL PROTECTED]>
To: "'Sapdb'" <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 1:21 PM
Subject: Re: Sapdb and petstore1.1.2
> People I find the error with the signon component of petstore 1.1.2 , the
> problem is the update. i show in an example:
>
> the line :
> String queryStr ="update signon set password='j2ee' where
username='j2ee'";
> it's the problem . currently i stay to work in resolve the problem (only
in
> the source but don't in the driver ) and send a the list , i think it's no
> very dificult . I hope
>
> --------------------------------------------------------------------------
--
> ---------------
> import java.util.Properties;
> import java.sql.*;
>
>
> //////////////////////////////////////////////////////////////////////
> public class HelloSapDB {
>
> //////////////////////////////////////////////////////////////////////
> public static void main (String [] args) throws
ClassNotFoundException,
> SQLException
> {
> String user;
> String password;
> String host = "200.100.10.53";
> String dbname;
>
> /*
> * parse arguments
> */
> Properties options = parseOptions (args);
> host = options.getProperty ("host", "200.100.10.53");
> dbname = options.getProperty ("dbname");
> user = options.getProperty ("user");
> password = options.getProperty ("password");
> String url = "jdbc:sapdb://" + host + "/" + dbname;
> /*
> * load driver and connect
> */
> Class.forName ("com.sap.dbtech.jdbc.DriverSapDB");
> System.out.println(url);
> Connection connection = DriverManager.getConnection (url, user,
> password);
>
> /*
> * execute update
> */
> String queryStr ="update signon set password='j2ee' where
> username='j2ee'";
> PreparedStatement stmt = connection.prepareStatement(queryStr);
> int resultCount = stmt.executeUpdate();
> if(resultCount!=1)
> System.out.println ("ERROR");
> else
> System.out.println ("SUCESFULL");
>
> }
>
> //////////////////////////////////////////////////////////////////////
> public static void usage (boolean error) {
> System.out.println ("Usage: java ... HelloSapDB -u name,pwd -d
> dbname [-n node]");
> if (error) {
> System.exit (2);
> }
> else {
> System.exit (0);
> }
> }
>
> //////////////////////////////////////////////////////////////////////
> public static Properties parseOptions (String[] args) {
> Properties result = new Properties ();
> boolean hasUser = false;
> boolean hasDb = false;
>
> for (int i = 0; i < args.length; ++i) {
> String currentArg = args [i];
> if (currentArg.charAt (0) != '-') {
> break;
> }
> char currentOpt = currentArg.charAt (1);
> switch (currentOpt) {
> case 'h':
> usage (false);
> break;
> case 'u':
> ++i;
> currentArg = args [i];
> int pos = currentArg.indexOf (',');
> result.put ("user", currentArg.substring (0, pos));
> result.put ("password", currentArg.substring (pos + 1));
> hasUser = true;
> break;
> case 'd':
> ++i;
> result.put ("dbname", args [i]);
> hasDb = true;
> break;
> case 'n':
> ++i;
> result.put ("host", args [i]);
> break;
> default:
> System.err.println ("invalid option " + currentOpt);
> usage (true);
> break;
> }
> }
> if (!hasUser || !hasDb) {
> usage (true);
> }
> return result;
> }
>
> }
>
> -------------------------------------------------------
>
> the ERROR is�:
>
> -------------------------------------------------------
> devteam@nazca:~/dev/sapdb > java HelloSapDB -u TEST,TEST -d PFR
> jdbc:sapdb://200.100.10.53/PFR
> Exception in thread "main" java.lang.NoSuchMethodError
> at java.math.BigDecimal.timesTenToThe(BigDecimal.java:922)
> at java.math.BigDecimal.<init>(BigDecimal.java:176)
> at
> com.sap.dbtech.util.VDNNumber.number2BigDecimal(VDNNumber.java:198)
> at com.sap.dbtech.util.VDNNumber.number2int(VDNNumber.java:278)
> at
> com.sap.dbtech.jdbc.packet.ReplyPacket.resultCount(ReplyPacket.java:371)
> at
>
com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.ja
> va:347)
> at
>
com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.ja
> va:265)
> at
>
com.sap.dbtech.jdbc.CallableStatementSapDB.executeUpdate(CallableStatementSa
> pDB.java:550)
> at HelloSapDB.main(HelloSapDB.java:46)
> -------------------------------------------------------
>
>
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
