Re: Postgres 8 & JBuilder X - Mailing list pgsql-jdbc

From guillermo@gnsis.net (Guillermo)
Subject Re: Postgres 8 & JBuilder X
Date
Msg-id c051570f.0409111048.719e3479@posting.google.com
Whole thread Raw
In response to Postgres 8 & JBuilder X  (guillermo@gnsis.net (Guillermo))
List pgsql-jdbc
I found the error; I repeated accidentaly a "Database" class
connecting to the same database, in 2 frames of the same package. It
seems that JBuilder does not accept this, generating the error.

Thank you any way
Guillermo

guillermo@gnsis.net (Guillermo) wrote in message news:<c051570f.0409100700.447c1f2b@posting.google.com>...
> Hi,
> I have searched the news group archive with info regarding the JDBC
> Connection of Postgres to JBuilder. I have JBuilder X Foundation and
> Postgres 8 for windows (beta 01). Following recomendations I saw in the news group
> archive, what I did is:
>
> 1- Create Library "Postgres"
> 2- Add all of the needed jar files to the Library
> 3- Setup the Project/Porject Options/ Required Library
> 4- <jbuilder>\bin\jbuilder.config file, adding a new "addpath" line that
> points to the PostgresSQL jar file (pg74.213.jdbc2ee.jar )
> 5- Modify the dbpilot.config inserting a line:
> org.postgresql.DriversampleUrl=jdbc\:postgresql\://localhost\:5432/cofeebrea
> k
> where cofeebreak is my Postgres 8 database.
>
> Using the DBPilot I cannot get the db connected:
>
> a- I don't get in the "Driver" pulldown the connection I inserted in
> "bpilot.config"
> b- If I type it manually, and Test the Connection I get: "Chain of 2 or more
> Exceptions occurred"; when pressing the "details" button to get a kind of
> stack trace, nothing happens.
>
> The funny thing is that in the test Java application, I have 2 frames: a
> parent (main) and the child. Even when in the dbPilot I could not estalish
> the connection, if I put a JdbTable in the Main Frame showing data of the
> Postgres table, it shows it with no problems when the app. is executed. If I
> put the JdbTable in the child frame, I get the error I got in the Test
> Connection of the dbPilot, and now I can see a Stack Trace (listed below).
> When I want to connect to JDataStore, I have no problems at all. Could it be
> a problem in postgresql 8, since it is a beta version for windows?
>
> I'd appreciate any help.
> Thank you,
> Guillermo
>
> StackTrace:
>
> See com.borland.dx.dataset.DataSetException error code:  BASE+47
>
> com.borland.dx.dataset.DataSetException: Chain of 2 or more Exceptions
> occurred
>
>  at com.borland.dx.dataset.DataSetException.a(Unknown Source)
>
>  at com.borland.dx.dataset.DataSetException.throwExceptionChain(Unknown
> Source)
>
>  at com.borland.dx.sql.dataset.q.a(Unknown Source)
>
>  at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
>
>  at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown
> Source)
>
>  at com.borland.dx.sql.dataset.o.a(Unknown Source)
>
>  at com.borland.dx.sql.dataset.o.d(Unknown Source)
>
>  at com.borland.dx.sql.dataset.o.f(Unknown Source)
>
>  at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
>
>  at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
>
>  at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
>
>  at com.borland.dx.dataset.DataSet.a(Unknown Source)
>
>  at com.borland.dx.dataset.DataSet.open(Unknown Source)
>
>  at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2749)
>
>  at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2733)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at javax.swing.JRootPane.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at java.awt.Window.addNotify(Unknown Source)
>
>  at java.awt.Frame.addNotify(Unknown Source)
>
>  at java.awt.Window.show(Unknown Source)
>
>  at lyr.FrameMain.jMenuBancos_actionPerformed(FrameMain.java:155)
>
>  at
> lyr.FrameMain_jMenuBancos_actionAdapter.actionPerformed(FrameMain.java:183)
>
>  at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>
>  at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown
> Source)
>
>  at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
>
>  at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
>
>  at javax.swing.AbstractButton.doClick(Unknown Source)
>
>  at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
>
>  at
> javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Unkno
> wn Source)
>
>  at java.awt.Component.processMouseEvent(Unknown Source)
>
>  at java.awt.Component.processEvent(Unknown Source)
>
>  at java.awt.Container.processEvent(Unknown Source)
>
>  at java.awt.Component.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Container.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Component.dispatchEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
>
>  at java.awt.Container.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Window.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Component.dispatchEvent(Unknown Source)
>
>  at java.awt.EventQueue.dispatchEvent(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>  at java.awt.EventDispatchThread.run(Unknown Source)
>
> Chained exception:
>
> javax.naming.NoInitialContextException: Need to specify class name in
> environment or system property, or as an applet parameter, or in an
> application resource file:  java.naming.factory.initial
>
>  at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
>
>  at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
>
>  at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
>
>  at javax.naming.InitialContext.lookup(Unknown Source)
>
>  at com.borland.dx.sql.dataset.q.a(Unknown Source)
>
>  at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
>
>  at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown
> Source)
>
>  at com.borland.dx.sql.dataset.o.a(Unknown Source)
>
>  at com.borland.dx.sql.dataset.o.d(Unknown Source)
>
>  at com.borland.dx.sql.dataset.o.f(Unknown Source)
>
>  at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
>
>  at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
>
>  at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
>
>  at com.borland.dx.dataset.DataSet.a(Unknown Source)
>
>  at com.borland.dx.dataset.DataSet.open(Unknown Source)
>
>  at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2749)
>
>  at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2733)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at javax.swing.JComponent.addNotify(Unknown Source)
>
>  at javax.swing.JRootPane.addNotify(Unknown Source)
>
>  at java.awt.Container.addNotify(Unknown Source)
>
>  at java.awt.Window.addNotify(Unknown Source)
>
>  at java.awt.Frame.addNotify(Unknown Source)
>
>  at java.awt.Window.show(Unknown Source)
>
>  at lyr.FrameMain.jMenuBancos_actionPerformed(FrameMain.java:155)
>
>  at
> lyr.FrameMain_jMenuBancos_actionAdapter.actionPerformed(FrameMain.java:183)
>
>  at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
>
>  at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown
> Source)
>
>  at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
>
>  at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
>
>  at javax.swing.AbstractButton.doClick(Unknown Source)
>
>  at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
>
>  at
> javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Unkno
> wn Source)
>
>  at java.awt.Component.processMouseEvent(Unknown Source)
>
>  at java.awt.Component.processEvent(Unknown Source)
>
>  at java.awt.Container.processEvent(Unknown Source)
>
>  at java.awt.Component.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Container.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Component.dispatchEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
>
>  at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
>
>  at java.awt.Container.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Window.dispatchEventImpl(Unknown Source)
>
>  at java.awt.Component.dispatchEvent(Unknown Source)
>
>  at java.awt.EventQueue.dispatchEvent(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>
>  at java.awt.EventDispatchThread.run(Unknown Source)

pgsql-jdbc by date:

Previous
From: Leo Martin Orfei
Date:
Subject: Re: problems returning a resultset from a function
Next
From: Antonini Roberto
Date:
Subject: function parameters