7.1: How to debug MinDB on laptop

[Former Member]

Dear all,

I am developing a mobile solution for handhelds with 7.1. Using the PDA emulator on my PC a MinDB is created in MI\data\dba. I can even see the directory for my data objects, e.g. MI\data\dba\M21UTYPE. The files in that directory obviously contain my data, but not in a readable form.

How can I check the contents? any tools available? I just need a list of records.

Thanks, Andre

[stefan_henke · Accepted solution]

Hi Andre,

I managed to do access the mindb using DBVisualizer. But there are some tricks you have to do:

1) Don´t use the latest version of DBVisualizer. For me, version 4.3.6 worked fine

2) You have to register a new driver in the Driver Manager area. Go to "Tools ->Driver Manager" and add a new entry called "MinDB". Specify an URL format like "jdbc:embeddedMinDB://?minDB= SQL Statements".Each SQL statement template contains a section "$$schema$$$$schemaseparator$$". This is currently not supported by MinDB and has to be removed. For example the template for SELECT ALL should look like "select * from $$table$$"

Now you should be able to browse through the tables and their content.

Regards,

Stefan

[Former Member · Accepted solution]

Thanks Stefan,

that works ...

Andre

[Former Member]

Just to put it to the top of the list again ...

any new input?

Andre

[Former Member]

Does anyone have an idea how to set the "Driver"? Please see screen shots in my previous message.

Thanks, Andre

[Former Member]

Hi Sivakumar,

thanks. Especially for the Connection details. I could not find them anywhere in the SAP docs.

Unfortunately I don't know how to choose one of the connection parameters. Please see 2 screenshots:

- choose driver: [http://img67.imageshack.us/img67/7339/20080704090641oe8.jpg]

- DB URL: [http://img370.imageshack.us/img370/6632/20080704101329ac9.jpg]

None of the drivers accepts the DataBase URL that you suggested. I modified it to point to my MinDB, but It complains about a syntax error.

Any idea?

Thanks

Andre

[Former Member]

Hi Andre,

Although there is not standard tool available to view the data contents of MinDB, one of the easier tools to use for the same is DBVisualizer and the same can be downloaded from [here|http://www.minq.se/download/validator.jsp]

Once you have installed the same, Create a new connection called MinDB, Database type as Generic, Database URL as jdbc:embeddedMinDB://?minDB=C:\MinDBData (Note: Change C:\MINDBData to the location where your data resides.) The user name and password would be DBA and DBA unless you have changed the same.

Hope this helps.

Best regards

Sivakumar