Sorry all! - I made a stupid mistake in my java code.. It works now. Thanks for all the help! Cheers, /m
On Fri, 14 Feb 2003 12:00:39 +0100, Marcus Berglund wrote: > Hi all! > I cant seem to connect using jdbc. > I created a database by modifying the script that creates the test > database. I also created the user bcuser using this sql statement: > > sql_execute CREATE USER bcuser PASSWORD bcpass RESOURCE NOT EXCLUSIVE > DEFAULTCODE UNICODE > This seems to have worked. I installed websql/webdbm and I can log on to > websql using my bcuser. I can also execute a query successfully (select * > from tables) using websql. > When using the dbmcli user_getall I dont see bcuser listed - am I right in > thinking that user_getall only lists administrative accounts known to the > database? > > Anyway, when using the HelloSapDB test util distributed with sapdb, I get > this: > [sapdb@nerdling sapdb]$ java -classpath lib/sapdbc.jar:. HelloSapDB -u bcuser,bcpass >-d soprano > Exception in thread "main" com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP >DBTech JDBC: Cannot connect to jdbc:sapdb://nerdling/null [Restart required]. >at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:193) > at java.sql.DriverManager.getConnection(DriverManager.java:512) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at HelloSapDB.main(HelloSapDB.java:26) > > I tried running it as user dbm as well but I get exactly the same > response. When issuing "dbmcli -u dbm,dbm -d soprano user_get dbm" I get > this: > OK > >SERVERRIGHTS=DBInfoRead,ExecLoad,UserMgm,DBFileRead,Backup,InstallMgm,LoadSysTab,ParamCheckWrite,ParamFull,ParamRead,DBStart,DBStop,Recovery,AccessSQL,AccessUtility > GUIRIGHTS= > SECONDPASSWORD=NO > DISABLED=NO > COMMENT= > > - Im running RedHat 8 and sapdb: "7.4.3","UNIX","/opt/sapdb/depend",False,ASCII,2 > > Does anyone have any clues as to why I cant connect using jdbc? > Cheers, > /m > > > On Thu, 13 Feb 2003 17:51:57 +0100, Marcus Berglund wrote: > >> Thanks for the quick response! >> I managed to create a user using the dbmcli command (create_user >> user,password). However, from your response I noticed that this was not >> the way I should have done (thanks again) it as I just want to create a regular >user that >> can connect to the db (the goal is for that user to be able to use jdbc to >> access the database). >> So trying out the second alternative: >> >> [sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano >> dbmcli on soprano>sql_execute CREATE USER bcuser PASSWORD bcpass >> ERR >> -24988,ERR_SQL: sql error >> -5001,Missing privilege:DBA >> >> Ok - to minimize the risk of idiot-errors: >> - Am I wrong in thinking that the user dbm really is a dbm? >> How do I get sql access ? >> what username should I use with the dbmcli ? >> Should I use the username,password I used when installing sapdb? >> I used uid:sapdb,gid:sapsys but I get a user authorization failure when trying to >> run dbmcli using it). >> >> I tried finding some relevant information here (couldnt find the relevant >> info in the official online docs) : >> >http://www.rst-consult.com/database/sapdb/dbmcli_us_html.html#0.2.3.3.3CreatingandchangingdatabaseusersinTST|outline >> but the output from the "dbmcli -n localhost -d soprano -u dbm,dbm >> user_get dbm"-command does not look the output I'm getting. This is what I >> get: >> dbmcli on localhost : soprano>user_get dbm >> OK >> >SERVERRIGHTS=DBInfoRead,ExecLoad,UserMgm,DBFileRead,Backup,InstallMgm,LoadSysTab,ParamCheckWrite,ParamFull,ParamRead,DBStart,DBStop,Recovery,AccessSQL,AccessUtility >> GUIRIGHTS= >> SECONDPASSWORD=NO >> DISABLED=NO >> COMMENT= >> >> I use Linux and as far as I can tell there is no "SQLStudio" available for >> download. >> >> I feel that these are extremely basic questions but I just cant seem to >> find any relevant information that works for me (the commands I try from >> the docs on the rst-consult website just gives me errors and I just cant >> seem to find any relevant info in the sapdb online docs.). >> >> Have I missed some basic howto that deals with this? >> I've sofar checked out these links (apart from the sap online docs): >> http://www.mybytes.de/sapdb/ >> http://www.rst-consult.com/database/sapdb/odbc_us/index.html >> >> I would really appreciate a pointer in the right direction.. >> Cheers, >> /m >> >> >> On Thu, 13 Feb 2003 15:31:23 +0100, Schroeder, Alexander wrote: >> >>> Hi all, >>> >>> again to remember: >>> >>> There are dbm operators and there are database users. Apparently Zsolt and Marcus >>> wanted to create the second one (a database user)- >>> >>> A dbm operator (generally, one who can execute all these fine dbmcli command, >>> and utilise DBMGUI to monitor the database, make backups, etc. >>> can be create with that user_create command: >>> >>> http://www.sapdb.org/7.4/htmhelp/29/4e6939474e11d4aa1100a0c9430730/content.htm >>> >>> In contrast, a database user is create using the SQL statement CREATE USER: >>> >>> http://www.sapdb.org/7.4/htmhelp/48/f0daa5225811d3a97d00a0c9449261/content.htm >>> >>> If you want to execute a SQL command from dbmcli, you have to prefix it with >>> sql_execute: >>> >>> http://www.sapdb.org/7.4/htmhelp/fd/9a05e4613411d4aa1500a0c9430730/content.htm >>> >>> You can of course issue the CREATE USER statement not only from dbmcli, but also >>> from SQL Studio, for instance. >>> >>> Regards >>> Alexander Schr�der >>> SAP Labs Berlin >>> >>>> -----Original Message----- >>>> From: Andreas Ernst [mailto:[EMAIL PROTECTED]] >>>> Sent: Thursday, February 13, 2003 3:13 PM >>>> To: Marcus Berglund <[EMAIL PROTECTED]>; SAPDB >>>> Subject: Re: Newbie question: creating a user >>>> >>>> >>>> Hi, >>>> >>>> try: >>>> >>>> [sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano >>>> >>>> > help >>>> >>>> and you get all commands.... >>>> >>>> and at the end ot the list >>>> >>>> user_create >>>> >>>> HTH >>>> Andreas >>>> >>>> Marcus Berglund schrieb: >>>> >>>> >I have the same problem. The problem for me is not the syntax of the >>>> >command but how to execute it. When using the dbmcli I get this: >>>> > >>>> >[sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano >>>> >dbmcli on soprano>create user testuser password pwd not exclusive >>>> >ERR >>>> >-24977,ERR_COMMAND: unknown command "create" >>>> > >>>> >I guess Im not supposed to use the dbmcli for this - but what am I >>>> >supposed to use to get a regular SQL session going with my db?? >>>> >Would appreciate some help.. >>>> > >>>> > >>>> >--- >>>> > >>>> >--- In [EMAIL PROTECTED], "Zabach, Elke" >>>> ><[EMAIL PROTECTED]> wrote: >>>> > >>>> > >>>> >>Zsolt Almasi wrote: >>>> >> >>>> >> >>>> >> >>>> >>>Can you tell me , how can I create a Standard user ? I will >>>> >>>apreciate if you >>>> >>>can show me some examples ! >>>> >>> >>>> >>> >>>> >>the reference-manual is too complicate to understand this? >>>> >>(see chapter Authorization --> create user ) >>>> >> >>>> >> >>>> >> >>>> >http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c944926 >>> 1/frameset.htm >>>> >>>> >>>>>example >>>>>create user xyz password abc >>>>> >>>>>Elke >>>>>SAP Labs Berlin >>>>>_______________________________________________ >>>>>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 >>>> >>>> >>>> >>> >>> >>> >>> >>> _______________________________________________ >>> 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
