Hello, I've written a Java program that creates/recover a database. It's based on an XML-file which specifies the database properties. If you are interressed in, you can contact me...
regards, Kolja -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von jlegeny Gesendet: Donnerstag, 7. August 2003 14:31 An: [EMAIL PROTECTED] Betreff: RE: Create DB instance using java Hi, thank you for your answer. I would like to ask you, how can I create new DB instance first and then set up the parameters. I want to create for example new db instance "TEST_DB" (it doesn't exist yet) and then set up for example parameter CAT_CACHE_SUPPLY = 600. I have try your java example and used command 'db_create'. (Is it neccessary to have x_server started, if yes, how can I do it in JAVA?). Properties pt = new Properties(); pt.setProperty("host", "localhost"); pt.setProperty("dbname", "TEST_DB"); String dbuser = "DBM"; String dbpasswd = "DBMPASSWORD"; String result = null; DBM mydbm = new DBM(pt); // is this command correct for creating new instance??? result = mydbm.cmd("db_create"); but the error was occured: ================================================= com.sap.dbtech.rte.comm.RTEException: Server or DB unknown StandardDataSource:getConnection Cannot get connection for URL jdbc:sapd b://localhost/TST1 : SAP DBTech JDBC: Cannot connect to jdbc:sapdb://localhost/TEST_DB [Restart required]. ================================================= Can you send me please a short example (step by step) how to do it by JAVA. 1. create new db instance "TEST_DB" into <INSTALL_PATH> directory (dbmcli -R <INSTALL_PATH> db_create <DB_NAME> dbm,dbm) 2. set up parameter CAT_CACHE_SUPPLY = 600 (param_put CAT_CACHE_SUPPLY 300) 3. set up DATA volume size to 50 MB (param_addvolume 1 DATA <DIR_VOLUME>\<DB_NAME>\DISKD0001 F 51200) 4. something else what is important for successfull db instance installation Thank you in advance for your response, Julian Schroeder, Alexander wrote: > Hello Julian, > > You simply need to do something like this > import com.sap.dbtech.powertoys.DBM; > ... > > .. somewhere in code > > Properties pt = new Properties(); > pt.setProperty("host", "localhost"); > pt.setProperty("dbname", "DB74"); > String dbuser = "DBM"; > String dbpasswd = "DBMPASSWORD"; > String result = null; > > DBM mydbm = new DBM(pt); > result = mydbm.cmd("user_logon " + dbuser +","+dbpasswd); > result = mydbm.cmd("param_startsession"); > ... > > mydbm.release(); > > ... > > 'result' contains the text that would appear on the dbmcli console, > that is 'OK' on most commands. > Keep in mind that for Java access the x_server must be started, as it > uses TCP/IP to > connect to the database. > > Regards > > Alexander Schr�der > SAP DB, SAP Labs Berlin > > >> -----Original Message----- >> From: jlegeny [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 07, 2003 11:08 AM >> To: [EMAIL PROTECTED] >> Subject: Create DB instance using java >> >> >> Hi, >> how can I create new database instance and set database parameters >> (MAXDATADEVSPACES, MAXUSERTASKS, CAT_CACHE_SUPPLY, number and size of >> data/log volumes, ...) IN JAVA? >> Is it possible to do it using java API ? >> >> For dbmcli is used 'com.sap.dbtech.powertoys.DBM' package. >> I need to know, how can I setup database parameters (followed under) >> in JAVA. >> >> param_startsession >> param_init OLTP >> param_put CAT_CACHE_SUPPLY 300 >> param_checkall >> param_commitsession >> param_addvolume 1 DATA %DIR_VOLUME%\%DATABASE_NAME%\DISKD0001 F 51200 >> >> Thanks for your answer, >> Julian >> _______________________________________________ >> 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
