Connecting Tech Pros Worldwide Forums | Help | Site Map

Java JDBC Shared access

Familiar Sight
 
Join Date: Nov 2007
Posts: 153
#1: Jun 22 '09
Hi all,

I have been working with java on a database program that connects via jdbc odbc access driver on my xp desktop.

It is working fine but I'm installing it on 3 pc's tomorrow so testing it on my vista laptop now.

When i go to configure dsn on vista laptop and access database via my Z drive it is now calling a java.sql.sqlexception on load of jar file.

Question 1 Can accdb have multiple conections? (please say yes!)

Question 2 Can anyone suggest the soluiton to the exception?

Regards

Brendan

JosAH's Avatar
Expert
 
Join Date: Mar 2007
Posts: 10,611
#2: Jun 23 '09

re: Java JDBC Shared access


Quote:

Originally Posted by brendanmcdonagh View Post

Question 1 Can accdb have multiple conections? (please say yes!)

I don't know what 'accdb' is but I suggest you read the manuals that come with it.

Quote:

Originally Posted by brendanmcdonagh View Post

Question 2 Can anyone suggest the soluiton to the exception?

No, because you didn't show is the relevant piece of code that caused the Exception to be thrown nor did you show us the stack trace; most of us aren't clairvoyant.

kind regards,

Jos
Familiar Sight
 
Join Date: Nov 2007
Posts: 153
#3: Jun 23 '09

re: Java JDBC Shared access


It was a permissions issue - You need to allow read/write permissions on the folder the database is stored in. All Done now!

Thank you for your help Jos this week.

I feel like I've come a long way since HelloWorld.java

Just out of curiosity, What would a databse program cost (read, write, edit, delete, search options with it as well as creating an invoice with the fields entered). Just wondering if it's time to get a job in this field?!!
JosAH's Avatar
Expert
 
Join Date: Mar 2007
Posts: 10,611
#4: Jun 23 '09

re: Java JDBC Shared access


Quote:

Originally Posted by brendanmcdonagh View Post

It was a permissions issue - You need to allow read/write permissions on the folder the database is stored in. All Done now!

Thank you for your help Jos this week.

I feel like I've come a long way since HelloWorld.java

Just out of curiosity, What would a databse program cost (read, write, edit, delete, search options with it as well as creating an invoice with the fields entered). Just wondering if it's time to get a job in this field?!!

You're welcome of course; Java 1.6 comes bundled with JavaDB which is Sun's version (read: clone) of Apache's Derby database system; it's a complete SQL engine and it can do everything you described above and then some. It costs you nothing.

You at least need to know something about table normalization (e.g. Boyce Codd normal forms etc.), views on (joins of) tables, transactions etc. to get a decent job in the database field.

kind regards,

Jos
Reply