Hi Tanu, can you connect and execute statements via dbmcli:
dbmcli -uSQL test,test -u dbm,dbm -d TST74 sql_execute select 1 from dual ? Also, did the create_demo_db.sh script run without any error messages? -4008 means username/password unknown. This is quite ok if you try with the dbm, as dbm is a database operator, not an user suitable for SQL execution etc. But normally the test user should work, and also the message "Unknown user name/password combination" should be shown whenever this error occurs, so I assume something bad happened during DB creation. The script create_demo_db.sh drops the db and recreates it again, if run twice, so you may try again from here. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Tanu Shankar Bhatnagar [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 10, 2003 2:56 PM > To: [EMAIL PROTECTED] > Subject: issue with jdbc connection > > > I get the following exception when I use the HelloSapDB.java example: > > Exception in thread "main" > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4008]: Message not > available > at > com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPa > cket.java:69) > at > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSa > pDB.java:748) > at > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:422) > at > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:316) > at > com.sap.dbtech.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB. > java:268) > at > com.sap.dbtech.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:79) > at > com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:199) > at > java.sql.DriverManager.getConnection(DriverManager.java:517) > at > java.sql.DriverManager.getConnection(DriverManager.java:177) > at HelloSAPDB.main(HelloSAPDB.java:54) > > Here are the details about my config: > 1. running sapdb 7.4 on linux (RedHat 8.0); have installed > all 7 rpms for > linux (server, independent s/w, web tools, interfaces, precompiler and > sampledb) > 2. i used the dbmcli to start the db before running the example > 3. i had to change the dbname from TST to TST74 to start the > db through > dbmcli > 4. i have tried to run this example as user DBM/DBM and > TEST/TEST both, > nothing works (i.e. I get the same exception as above) > 5. i definitely have the jdbc jar in my classpath > 6. for some reason, i am not able to run ireport.py script. I > searched for > files under /opt/sapdb, but did not find this file. Am I > missing something > here? > > If someone could tell me why I am not able to connect through > JDBC to the > db, I would greatly appreciate it. The exception above does > not have any > message in it and I am not able to make much of it. > > Thanks in advance, > Tanu > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
