Xojo Conferences
XDCMay2019MiamiUSA

[MBS] JDBC database access (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] Repost - 8.3pr4 and Console applications
Next thread: [MBS] 8.3pr4


RE: [MBS] DOM classes for Mac OS X HTMLViewer   -   Giovanni
  [MBS] JDBC database access   -   Christian Schmitz
   Re: [MBS] JDBC database access   -   Charles E. Heizer
    Re: [MBS] JDBC database access   -   Christian Schmitz
     Re: [MBS] JDBC database access   -   Charles E. Heizer
      Re: [MBS] JDBC database access   -   Christian Schmitz
      Re: [MBS] JDBC database access   -   Christian Schmitz
       Re: [MBS] JDBC database access   -   Charles E. Heizer
        Re: [MBS] JDBC database access   -   Christian Schmitz
    [MBS] Re: AXObserverMBS not working   -   Pencil

[MBS] JDBC database access
Date: 25.04.08 10:25 (Fri, 25 Apr 2008 11:25:04 +0200)
From: Christian Schmitz
Hi,

I made that JavaDatabaseMBS class a few days ago, because some people
asked over time for database access beside RB's built in ways.

You basicly need Java installed and the JDBC driver for your database
and the plugin should handle the rest for you. I could integrate with
RB's database class, but I think I may first go without so RB Standard
users can use it.

So what do you think?

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 25.04.08 17:46 (Fri, 25 Apr 2008 09:46:45 -0700)
From: Charles E. Heizer
Way to go, I have been wondering why RS had not done it long ago!

Is it a console safe class?

- Charles

On 4/24/08 3:41 PM, "Christian Schmitz" <<email address removed>> wrote:

Hi,

I made that JavaDatabaseMBS class a few days ago, because some people
asked over time for database access beside RB's built in ways.

You basicly need Java installed and the JDBC driver for your database
and the plugin should handle the rest for you. I could integrate with
RB's database class, but I think I may first go without so RB Standard
users can use it.

So what do you think?

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 25.04.08 18:30 (Fri, 25 Apr 2008 19:30:44 +0200)
From: Christian Schmitz
Charles E. Heizer <<email address removed>> wrote:

> Way to go, I have been wondering why RS had not done it long ago!
>
> Is it a console safe class?

I can make this console safe.
But the question is how the need is for such a solution.

The existing class is more a proof of concept than a real solution.
It needs to be tested on Windows and linux and needs a lot of more code
to handle memory management correct.

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 25.04.08 18:44 (Fri, 25 Apr 2008 10:44:51 -0700)
From: Charles E. Heizer
I have some console based applications which query mysql databases to both post and retrieve system information. Right now I'm using a http post, but with this I can eliminate the need to maintain the http files. This would also allow me to use other databases like Oracle with little effort.

Thanks,
- Charles

On 4/25/08 10:30 AM, "Christian Schmitz" <<email address removed>> wrote:

Charles E. Heizer <<email address removed>> wrote:

> Way to go, I have been wondering why RS had not done it long ago!
>
> Is it a console safe class?

I can make this console safe.
But the question is how the need is for such a solution.

The existing class is more a proof of concept than a real solution.
It needs to be tested on Windows and linux and needs a lot of more code
to handle memory management correct.

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 25.04.08 20:53 (Fri, 25 Apr 2008 21:53:56 +0200)
From: Christian Schmitz
Charles E. Heizer <<email address removed>> wrote:

> I have some console based applications which query mysql databases to both
> post and retrieve system information. Right now I'm using a http post, but
> with this I can eliminate the need to maintain the http files. This would
> also allow me to use other databases like Oracle with little effort.
>

Well, if you like, take some time and try the mysql example.
And try oracle if you like.

We can work together to improve this class.
Tell me what you need and what errors you see.

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 29.04.08 01:44 (Tue, 29 Apr 2008 02:44:21 +0200)
From: Christian Schmitz
Charles E. Heizer <<email address removed>> wrote:

> I have some console based applications which query mysql databases to both
> post and retrieve system information. Right now I'm using a http post, but
> with this I can eliminate the need to maintain the http files. This would
> also allow me to use other databases like Oracle with little effort.

Can you try the 8.3pr7 release?

I added more methods for the java database classes and it should now
work on Windows.

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 29.04.08 16:18 (Tue, 29 Apr 2008 08:18:44 -0700)
From: Charles E. Heizer
Hi Christian,
So I started playing with the JDBC and I'm running in to a couple of issues. Once connected to the database I have no way to verify that connection (e.g. j.connected = True) I also do not see a way to close the connection. For example I did a small test similar to your example where I'm just adding the select result to a listbox, the first time I run it it adds the result, the next time I push the button it give the error "not connected, 0".

I would also like to request that a record count be added to the JavaRecordSetMBS class.

I sent this email yesterday but it said it needed review since it was over 5k. I included some source code which I have removed this time.

Thanks, and keep up the good work!

- Charles

On 4/28/08 5:44 PM, "Christian Schmitz" <<email address removed>> wrote:

Charles E. Heizer <<email address removed>> wrote:

> I have some console based applications which query mysql databases to both
> post and retrieve system information. Right now I'm using a http post, but
> with this I can eliminate the need to maintain the http files. This would
> also allow me to use other databases like Oracle with little effort.

Can you try the 8.3pr7 release?

I added more methods for the java database classes and it should now
work on Windows.

Gruß
Christian

-

Re: [MBS] JDBC database access
Date: 29.04.08 16:43 (Tue, 29 Apr 2008 17:43:58 +0200)
From: Christian Schmitz
Charles E. Heizer <<email address removed>> wrote:

> Hi Christian,
> So I started playing with the JDBC and I'm running in to a couple of
> issues. Once connected to the database I have no way to verify that
> connection (e.g. j.connected = True)

I've added that for the next pr.
isConnected as boolean

> I also do not see a way to close the connection.

it is closed when the JavaDatabaseMBS object is destroyed.

> For example I did a small test similar to your example where I'm just
> adding the select result to a listbox, the first time I run it it adds the
> result, the next time I push the button it give the error "not connected,
> 0".

Strange. You should only have one instance of JavaDatabaseMBS.

> I would also like to request that a record count be added to the
> JavaRecordSetMBS class.

Added for next pr.

Gruß
Christian

-