You are not logged in.

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

gabizzz

Beginner

  • "gabizzz" is male
  • "gabizzz" started this thread

Posts: 5

Date of registration: Jun 18th 2009

Location: Argentina

  • Send private message

1

Thursday, June 18th 2009, 6:55pm

Connect to MySQL Database without Database component

The recommended way from the MySQL-website is connecting to the MySQL-Server through JDBC with the Connector/J-driver. MySQL Connector/J is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database.

The installation of this driver is very simple: Download the driver and copy the included Jar-file (e.g. "mysql-connector-java-3.0.17-ga-bin.jar") to the "[...]\jre\lib\ext"-folder in your current Java-installation.

The JDBC API is designed to make it possible for you to write a single Jabaco/Java program and to use it to manipulate the data in a variety of different SQL database servers without a requirement to modify and/or recompile the program.


Source code

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

Dim sql As Statement
Dim bd As Connection
Dim res As ResultSet

Public Sub Form_Load()
On Error Resume Next
Dim driver As Class 
driver = Class.forName("com.mysql.jdbc.Driver")
If driver = Nothing Then MsgBox "Not found!"
On Error Goto 0
bd = DriverManager.getConnection("jdbc:mysql://hostname:port/databasename, username, password)
End Sub
Public Sub Command2_Click()
sql = bd.createStatement()
sql.executeQuerry("select * from tablename") 'can use executeUpdate !!

list1.Clear

Do While res.next
list1.AddItem (res.getString("nombre")+(", ")+res.getString("apellido")+(", ")+res.getString("id"))
Loop
End Sub

This post has been edited 1 times, last edit by "gabizzz" (Jun 19th 2009, 1:09pm)

Jason

Beginner

Posts: 6

Date of registration: Jul 15th 2009

  • Send private message

2

Monday, August 10th 2009, 1:30pm

Distribution of drivers.

Hi
I'm pretty new to both Java and VB (I'm a Delphi Developer).

I have recreated the example above and it works fine, but if i create/deploy my application as an applet, it cant find the driver.

I kind of understand why this is, since the applet is essentially being downloaded and then embedded in the browser, so it loses the context of the jdk/jre and cant see the driver, I was just wondering how you get around this and that the best practice policy is for distributing applets. I would not like to have to force all the users on my intranet to install the Java JConnector driver. If someone could point me at a post or a body of ducumentation dealing with this, Id appreciate it.

Thanks

Jason

Beginner

Posts: 6

Date of registration: Jul 15th 2009

  • Send private message

3

Wednesday, August 19th 2009, 8:35am

Solved

Just in case anyone is interested.
I solved this problem after finding and reading this :

http://www.ericgiguere.com/articles/depl…va-applets.html

The trick is to add the driver to the archive downloads in your HTML file.

Quoted

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>
Jabaco-Applet
</title>
</head>
<body>
<APPLET ARCHIVE="dbtest.jar,mysql-connector-java-5.1.8-bin.jar" CODE="Applet1.class" WIDTH="400" HEIGHT="300">
<PARAM NAME="Compiler" VALUE="Jabaco">
</APPLET>
</body>
</html>

Similar threads

Rate this thread
WoltLab Burning Board