Hi, Viktor. I'm using SapDB with OJB (that uses some parts of Torque to do some internal work). I think the final results should be same, and the way of work too.
The first step you must is to create the database instance (SapDB/MaxDB works in a instance way - and each instance is called by itself a database). After you create your database instance (with SapDB for Linux came a test database called TST, that I'll use for samples bellow), you could create your database structure. In my day-by-day work, I create a dba user (CREATE USER XYZ PASSWORD 123 DBA NOT EXCLUSIVE) that will be my "Schema" name. I'll create all tables under this umbrella. Then, I connect to database with the following url: jdbc:sapdb://127.0.0.1/TST with user "XYZ" and password "123". Now, if I create a table T1, it will be known as "XYZ.T1" table (without quotes). Of course, you will not be using the TST database, so I recommend you to create the instance you will use, and configure parameters for later work (like number of connections, that is by default 50). After, I'll recommend you that your app not use the user XYZ to work in the system for production purposes. At contrary, you should create another user but don't forget to put NOT EXCLUSIVE, or it will be capable of work with one connection at time: CREATE USER ZZZ PASSWORD 234 NOT EXCLUSIVE Then you will need to grant access to your tables (for each table): grant SELECT, INSERT, UPDATE, DELETE on XYZ.T1 to ZZZ I expect this information helps. Best regards, Edson Richter -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
