You are not logged in.

yogiyang

Beginner

  • "yogiyang" started this thread

Posts: 8

Date of registration: Nov 12th 2013

  • Send private message

1

Friday, June 20th 2014, 4:52pm

What is missing to connect to MySQL or SQLite database

I am trying to develop my first Database accessing software.

Here is the code that I am using to connect to Database:

Source code

1
2
3
java#lang#Class.forName("com.mysql.jdbc.Driver")
conn = DriverManager.getConnection("jdbc:mysql://localhost/crm", "root", "")
st = conn.createStatement()

When I run my software it keeps giving error class not found exception.

What mistake am I doing here?

How can I access SQLite database easily and what dependency do I have to install on my PC?

TIA

Yogi Yang

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

  • Send private message

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

  • Send private message

3

Friday, June 20th 2014, 6:25pm

by the way...

I can highly recommend the H2 database engine.

Very slim and fast!

Here is a sample app:

http://www.jabaco.org/board/905-database…e.html#post3663

Dani

yogiyang

Beginner

  • "yogiyang" started this thread

Posts: 8

Date of registration: Nov 12th 2013

  • Send private message

4

Monday, June 23rd 2014, 5:59am

@Dani,

Thanks for the suggestions and links.

I will definitely look up H2.

But how can I access SQLite from Jabaco?

Have I to use the Java wrapper to access SQLite?

In VB6 I have been using VBRichClient ActiveX component for many years now. Are there any possibilities of being able to use it in Jabaco?

TIA

Yogi Yang

Rate this thread
WoltLab Burning Board