[JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
it continues ;) Original-Nachricht Betreff:[jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Datum: Wed, 07 Jan 2009 10:54:22 + Von:SourceForge.net nore...@sourceforge.net An: nore...@sourceforge.net Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=6022088 By: nobody thanx guys for the infor but i encountered another prob. i used the tns description syntax test1 (SISDB:oracle:DEV3.ADIN.CIPAL.BE:1521:DEV3.ADIN.CIPAL.BE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = GEDBora5.vm.cipal.net)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = DEV3.cipal.be))) :stage1:stagiair) but am getting the following error org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (I/O-uitzondering: NL Exception was generated) org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (I/O-uitzondering: NL Exception was generated) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:5 40) at it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl$2.getConnection(JdbcDBDataImp l.java:260) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSour ceUtils.java:112) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSource Utils.java:77) at it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl.getURL(JdbcDBDataImpl.java:21 8) at it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl.connect(JdbcDBDataImpl.java:3 20) at it.ama_mi.sis.framework.db.openjump.SISDBDSConnection.getData(SISDBDSConnect ion.java:47) at it.ama_mi.sis.framework.db.openjump.SISDBDSMetadata.readContexts(SISDBDSMeta data.java:37) at it.ama_mi.sis.framework.db.openjump.SISDBDSMetadata.getDatasetNames(SISDBDSM etadata.java:42) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $7.yield(AddDatastoreLayerPanel.java:270) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $2.run(AddDatastoreLayerPanel.java:76) at com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run (TaskMonitorManager.java:149) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: I/O-uitzondering: NL Exception was generated at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.init(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.init(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java: 35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne ctionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect ionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS ource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:851) ... 13 more thank you vee __ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=729480 -- Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
fixed one - and he found another one .. can be a good documentation if we continue that way ;) stefan Original Message Subject:[jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Tue, 02 Dec 2008 11:19:25 + From: SourceForge.net [EMAIL PROTECTED] To: [EMAIL PROTECTED] Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5747126 By: simonecampora Sorry for the double posting but I posted the wrong Exception before... I will copy paste the same message but adding the RIGHT Exception thrown. Thanks for the help to everybody,however now the connection seems to work properly, no geometry has been shown. First of all, I will post the problems that you solved to me: 1- Firstly I was using a wrong SID in the Oracle Connection Descriptor while creating my TNS string. I solved it looking directly into the tnsnames.ora of the server 2- As the last reply has shown to me, there was an unknown problem while recognizing the schema, hence when I used the - dash, everything worked fine! (I tried using the space instead because I misunderstood the guidelines.. !) Now my problem is another one: When I'm loading the SDO_GEOMETRY column it gives me in the status bar (in the bottom right corner of openjump main window) a yellow box saying: StatementCallback; uncategorized SQLException for SQL [SELECT SDO_TUNE.EXTENT_OF('MYUSER.MYTABLE','MYCOLUMNATTR') from DUAL t]; SQL state [9]; error CODE [44003]; ORA-44003: invalid SQL nameORA-06512: at MDSYS.SDO_TUNE line 881; nested exception is java.sql.SqlException: ORA-44003: invalid SQL nameORA-06512: at MDSYS.SDO_TUNE line 881 (Uncategorized SQL Exception) The problem is that I cannot see anything (I also tried changing the style) on my added layer. It could be a problem related to that exception? If you want I can link a screenshot. p.s. I tried opening the same SDO_GEOMETRY columns with other GIS tools like Manifold, and the data wew visualized properly, so I supose it could not be a problem of the data. thanks again for the help! Simone __ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=729480 - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
still problems... Original Message Subject:[jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Mon, 01 Dec 2008 13:41:23 + From: SourceForge.net [EMAIL PROTECTED] To: [EMAIL PROTECTED] Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5743030 By: simonecampora Hello, thanks for the help... I tried using that TNS string and now I switched problem :) When I'm opening the combo box to select my data (it seems to connect properly since the X red cross near the connection is now a big green spot!) it throws me that exception saying No description... java.lang.NullPointerException at java.util.Arrays.sort(Unknown Source) at com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionPanel.sortBy String(ConnectionPanel.java:158) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel .populateDatasetComboBox(AddDatastoreLayerPanel.java:219) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel .access$300(AddDatastoreLayerPanel.java:29) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $4.yield(AddDatastoreLayerPanel.java:154) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $8$1.run(AddDatastoreLayerPanel.java:327) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at java.awt.Window.setVisible(Unknown Source) at java.awt.Dialog.setVisible(Unknown Source) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLa yerPlugIn.execute(AbstractAddDatastoreLayerPlugIn.java:25) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPlugI n.execute(AddDatastoreLayerPlugIn.java:18) at com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(Ab stractPlugIn.java:130) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.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$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.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.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(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) what it could be? I tried looking into the code, but I cannot draw any conclusion... it seems to be related with the sorting but I don't know why. thanks Simone __ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=729480
Re: [JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection]
Hi, I get exactly this error message when I try to connect to a postgres/postgis database where geometry columns are not declared in the geometry_columns table. In this case, I still can do free queries with menu LayerRun query if I use the syntax select asbinary(geom_col),* from mytable where geom_col contains my geometry in ewkb format. Hope that helps Michaël Stefan Steiniger a écrit : still problems... Original Message Subject: [jump-pilot - Problems with PlugIns] RE: Problems getting Oracle Connection Date: Mon, 01 Dec 2008 13:41:23 + From: SourceForge.net [EMAIL PROTECTED] To: [EMAIL PROTECTED] Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=5743030 By: simonecampora Hello, thanks for the help... I tried using that TNS string and now I switched problem :) When I'm opening the combo box to select my data (it seems to connect properly since the X red cross near the connection is now a big green spot!) it throws me that exception saying No description... java.lang.NullPointerException at java.util.Arrays.sort(Unknown Source) at com.vividsolutions.jump.workbench.ui.plugin.datastore.ConnectionPanel.sortBy String(ConnectionPanel.java:158) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel .populateDatasetComboBox(AddDatastoreLayerPanel.java:219) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel .access$300(AddDatastoreLayerPanel.java:29) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $4.yield(AddDatastoreLayerPanel.java:154) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPanel $8$1.run(AddDatastoreLayerPanel.java:327) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at java.awt.Window.setVisible(Unknown Source) at java.awt.Dialog.setVisible(Unknown Source) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLa yerPlugIn.execute(AbstractAddDatastoreLayerPlugIn.java:25) at com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPlugI n.execute(AddDatastoreLayerPlugIn.java:18) at com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(Ab stractPlugIn.java:130) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.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$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.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.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(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) what it could be? I tried looking into the code, but I cannot draw any conclusion... it seems to be