Thread: Postgres 8 & JBuilder X

Postgres 8 & JBuilder X

From
guillermo@gnsis.net (Guillermo)
Date:
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)

Re: Postgres 8 & JBuilder X

From
Oliver Jowett
Date:
Guillermo wrote:

> 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)

This seems to be a JBuilder JNDI configuration problem, not a driver
problem.

-O

Re: Postgres 8 & JBuilder X

From
guillermo@gnsis.net (Guillermo)
Date:
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)