Hello Everyone! I need some help with JAVA swing. I am making an application using the jdbc. My access database is connected to my JAVA program but if i want the database to be displayed in my jTable on a button click then the button action simply doesn't work. There aren't any compilation errors. Please help!

03-19-2012, 09:39 PM

doWhile

Re: JDBC connection to connect access database by button click

Quote:

Originally Posted by Shreyas_cool

on a button click then the button action simply doesn't work. There aren't any compilation errors. Please help!

With the amount of information you've provided, saying it doesn't work is as useful as us saying 'then fix it'. Did you register an ActionListener for the Button? Post an SSCCE...

...NEVER let exceptions fall through like that. Do something with the exception so you know it was thrown. For instance, e.printStackTrace()

03-20-2012, 01:39 AM

DarrylBurke

Re: JDBC connection to connect access database by button click

And use code tags, not color tags for posting code.

db

edit

Quote:

Code:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

Dump the visual designer/code generator. It's not a beginner's tool.

03-20-2012, 12:49 PM

Shreyas_cool

Re: JDBC connection to connect access database by button click

after writing e.printStackTrace() in the catch block i got a whole lot of errors.
Here's the list:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7113)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3072)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
at java.sql.DriverManager.getConnection(DriverManager .java:579)
at java.sql.DriverManager.getConnection(DriverManager .java:243)
at my.hospital.hospitalUI.connect(hospitalUI.java:344 )
at my.hospital.hospitalUI.jButton7ActionPerformed(hos pitalUI.java:472)
at my.hospital.hospitalUI.access$500(hospitalUI.java: 24)
at my.hospital.hospitalUI$6.actionPerformed(hospitalU I.java:232)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.jav a:6504)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3321)
at java.awt.Component.processEvent(Component.java:626 9)
at java.awt.Container.processEvent(Container.java:222 9)
at java.awt.Component.dispatchEventImpl(Component.jav a:4860)
at java.awt.Container.dispatchEventImpl(Container.jav a:2287)
at java.awt.Component.dispatchEvent(Component.java:46 86)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4422)
at java.awt.Container.dispatchEventImpl(Container.jav a:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713 )
at java.awt.Component.dispatchEvent(Component.java:46 86)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:707)
at java.awt.EventQueue.access$000(EventQueue.java:101 )
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 677)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:90)

03-20-2012, 01:20 PM

Tolls

Re: JDBC connection to connect access database by button click

Do you have a valid Access database whose DSN is 'Hospital'?

03-20-2012, 06:21 PM

Shreyas_cool

Re: JDBC connection to connect access database by button click

Yes..

03-20-2012, 06:45 PM

Tolls

Re: JDBC connection to connect access database by button click

Well, ODBC doesn't seem to like it.
I'd have a look at Microsofts site and see if there's anything regarding your version of Access against ODBC against your version of Windows.