Re: AW: Create DB instance using java

jlegeny Thu, 14 Aug 2003 11:49:38 -0700

Hello Kolja, I have interested by your java program. Can you help me with my problem to create new db instance using JAVA ?

 Thank you in advance,
 Julian

Kolja Kleist wrote:

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


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Re: AW: Create DB instance using java

Reply via email to