Java JDBC Shared access

[brendanmcdonagh]

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.sqlexc eption 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]

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.

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

[brendanmcdonagh]

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]

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