473,323 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Java JDBC Shared access

153 100+
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
Jun 22 '09 #1
3 2288
JosAH
11,448 Expert 8TB
@brendanmcdonagh
I don't know what 'accdb' is but I suggest you read the manuals that come with it.

@brendanmcdonagh
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
Jun 23 '09 #2
brendanmcdonagh
153 100+
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?!!
Jun 23 '09 #3
JosAH
11,448 Expert 8TB
@brendanmcdonagh
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
Jun 23 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: JShurmatz | last post by:
If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web...
11
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
5
by: Hassan Naqvi | last post by:
Hi, Basically, I am Java developer. In past I have played with Oracle using Java (JDBC). But this is the time to play with IBM DB2 using Java (JDBC). So kindly help this DB2 newbie. I have a...
0
by: mailkhurana | last post by:
Hii , I am trying to use a type 2 driver to connect to DB2 0n AIX 5 I have a small java test to class to establish a conneciton with the db .. I am NOT using WAS or any appserver When I try to...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
0
oll3i
by: oll3i | last post by:
package library.common; import java.sql.ResultSet; public interface LibraryInterface { public ResultSet getBookByAuthor(String author); public ResultSet getBookByName(String name);
0
myusernotyours
by: myusernotyours | last post by:
Hi all, Am trying to create a Java Desktop App that uses Java Persistence in Netbeans. The database is MS Access but I tried with Mysql and got the same error. When I run the app( Create the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.