Hi Marcus, JDBC does use TCP even on local host, as Java does not know of shared memory. So, you will have to start the x_server program:
x_server start Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Marcus Berglund [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 12:01 PM > To: [EMAIL PROTECTED] > Subject: RE: Newbie question: creating a user > > > 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,Ins > tallMgm,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,Ins > tallMgm,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/4e6939474e11d4aa1100a0c943 > 0730/content.htm > >> > >> In contrast, a database user is create using the SQL > statement CREATE USER: > >> > >> > http://www.sapdb.org/7.4/htmhelp/48/f0daa5225811d3a97d00a0c944 > 9261/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/9a05e4613411d4aa1500a0c943 > 0730/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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
