|
From: JJeff <jef...@pa...> - 2007-05-24 01:14:25
|
I have a question. Doing a search didn;'t get me any results, so i don't know if this is a common problem or not. When I try to connect to a database, Oracle Thin Client, I get this message Error occured in IPlugin.sessionCreated() for SQL Entry Code Completion After clicking Ok on the error message pop-up, I can access the database, but a lot of features are disabled, including removing the limitation of 100 rows displayed (even though this has ben disabled form the global preferences), editing the database, and others. Am I missing something? My SQuirreL was working fine until I tried to connect to a DB2 database one day and since then, my ORACLE database connections have been acting up. The Stack Trace of the error is this: java.lang.RuntimeException: java.lang.ClassNotFoundException: [Lnet.sourceforge.squirrel_sql.plugins.codecompletion.prefs.PrefixedConfig; at net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:351) at net.sourceforge.squirrel_sql.plugins.codecompletion.CodeCompletionPlugin.sessionCreated(CodeCompletionPlugin.java:239) at net.sourceforge.squirrel_sql.client.plugin.PluginManager.sessionCreated(PluginManager.java:150) at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:460) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:172) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121) Caused by: java.lang.ClassNotFoundException: [Lnet.sourceforge.squirrel_sql.plugins.codecompletion.prefs.PrefixedConfig; at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:164) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at net.sourceforge.squirrel_sql.fw.util.Utilities$1.resolveClass(Utilities.java:340) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1575) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1496) at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1624) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351) at net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:344) ... 12 more Thanks -- View this message in context: http://www.nabble.com/Error-in-Squirrel-when-connecting-to-Database-tf3807469.html#a10775880 Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Gerd W. <bir...@t-...> - 2007-05-24 01:52:26
|
This looks much like a installation problem. It's pretty sure that it doesn't have anything to do with your DB connection. I'd simply try to reinstall SQuirreL. Gerd JJeff wrote: > I have a question. Doing a search didn;'t get me any results, so i don't know > if this is a common problem or not. > > When I try to connect to a database, Oracle Thin Client, I get this message > > Error occured in IPlugin.sessionCreated() for SQL Entry Code Completion > > After clicking Ok on the error message pop-up, I can access the database, > but a lot of features are disabled, including removing the limitation of 100 > rows displayed (even though this has ben disabled form the global > preferences), editing the database, and others. > > Am I missing something? My SQuirreL was working fine until I tried to > connect to a DB2 database one day and since then, my ORACLE database > connections have been acting up. > > The Stack Trace of the error is this: > > java.lang.RuntimeException: java.lang.ClassNotFoundException: > [Lnet.sourceforge.squirrel_sql.plugins.codecompletion.prefs.PrefixedConfig; > at > net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:351) > at > net.sourceforge.squirrel_sql.plugins.codecompletion.CodeCompletionPlugin.sessionCreated(CodeCompletionPlugin.java:239) > at > net.sourceforge.squirrel_sql.client.plugin.PluginManager.sessionCreated(PluginManager.java:150) > at > net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:460) > at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) > at > net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:172) > at > java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) > at > java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) > at > java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) > at java.awt.EventDispatchThread.run(EventDispatchThread.java:121) > Caused by: java.lang.ClassNotFoundException: > [Lnet.sourceforge.squirrel_sql.plugins.codecompletion.prefs.PrefixedConfig; > at java.net.URLClassLoader$1.run(URLClassLoader.java:200) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:188) > at > net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:164) > at java.lang.ClassLoader.loadClass(ClassLoader.java:306) > at java.lang.ClassLoader.loadClass(ClassLoader.java:251) > at > net.sourceforge.squirrel_sql.fw.util.Utilities$1.resolveClass(Utilities.java:340) > at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1575) > at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1496) > at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1624) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323) > at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945) > at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869) > at > java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351) > at > net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:344) > ... 12 more > > Thanks |
|
From: JJeff <jef...@pa...> - 2007-05-24 02:04:10
|
Thanks for your quick response, I have tried to re-install SQuirrel many time. I forgot to state that I am using version 2.2 Final. I tried to uninstall and reinstall 2.51, but the problem seemed get worse and I couldn't even log in to any of my databases, hitting errors about user name and pasword not matching even though SQLPlus had no problems with the username and password. I since reverted back to ver 2.2 and trying to find a solution to the problem. I will try again with the re-installation, but I am hoping for another solution. Thanks. Gerd Wagner wrote: > > This looks much like a installation problem. It's pretty sure that it > doesn't > have anything to do with your DB connection. > > I'd simply try to reinstall SQuirreL. > > Gerd > > -- View this message in context: http://www.nabble.com/Error-in-Squirrel-when-connecting-to-Database-tf3807469.html#a10776272 Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Gerd W. <bir...@t-...> - 2007-05-24 05:45:05
|
This now is a problem with your DB connection: In your driver window open your driver definition and look at the "Extra Class Path" tab. You must add the path to your driver jar here. When done the driver definition should be marked with a blue hook in the drivers window. Finally in your Alias definition make sure the right driver definition is used. Gerd JJeff wrote: > After trying to install 2.51, I get this error when connecting to the > database: > > Unexpected Error occured attempting to open an SQL connection. > > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver > at java.net.URLClassLoader$1.run(URLClassLoader.java:200) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:188) > at > net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:164) > at java.lang.ClassLoader.loadClass(ClassLoader.java:306) > at java.lang.ClassLoader.loadClass(ClassLoader.java:251) > at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:247) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:128) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97) > at > net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:283) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) > at java.lang.Thread.run(Thread.java:619) > > So, I was thinking it's something wrong on my side since the installation > should be working for most other people. Is it some Windows Setting issue? > Am using it on WinXP. > > Thanks > > Jeff > > > JJeff wrote: >> Thanks for your quick response, I have tried to re-install SQuirrel many >> time. >> >> I forgot to state that I am using version 2.2 Final. I tried to uninstall >> and reinstall 2.51, but the problem seemed get worse and I couldn't even >> log in to any of my databases, hitting errors about user name and pasword >> not matching even though SQLPlus had no problems with the username and >> password. >> >> I since reverted back to ver 2.2 and trying to find a solution to the >> problem. I will try again with the re-installation, but I am hoping for >> another solution. >> >> Thanks. >> >> >> >> Gerd Wagner wrote: >>> This looks much like a installation problem. It's pretty sure that it >>> doesn't >>> have anything to do with your DB connection. >>> >>> I'd simply try to reinstall SQuirreL. >>> >>> Gerd >>> >>> >> > |
|
From: Robert M. <rob...@gm...> - 2007-05-24 11:36:31
|
On 5/24/07, Gerd Wagner <bir...@t-...> wrote: > This now is a problem with your DB connection: > In your driver window open your driver definition and look at the "Extra Class > Path" tab. You must add the path to your driver jar here. When done the driver > definition should be marked with a blue hook in the drivers window. > > Finally in your Alias definition make sure the right driver definition is used. Going back and forth between 2.5.1 and 2.2 is not something we tested specifically. I think it should be fine if no changes to aliases or driver defs is made after switching versions. However, we converted the format of the older SQLAliases.xml to SQLAliases23.xml in version 2.3 and above. So - correct me if I'm wrong Gerd - but there could be some issue related to saving alias definitions after installing/un-installing 2.5.1 (which creates the SQLAliases23.xml file) then modifying alias definitions using 2.2 - which uses SQLAliases.xml - and then going back into 2.5 and attempting to use them. The other gotcha that I think you might be seeing (PrefixedConfig class missing) is attempting to install different versions in the same directory location. This is not something that we currently support and the installer should warn you against doing this. I would recommend installing 2.5.1 in a fresh location and giving it one more try (fixing any issues with driver/alias defs you encounter as Gerd suggested). Let us know how it goes. Rob |
|
From: JJeff <jef...@pa...> - 2007-05-24 02:55:18
|
After trying to install 2.51, I get this error when connecting to the database: Unexpected Error occured attempting to open an SQL connection. java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:164) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:128) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97) at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:283) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:619) So, I was thinking it's something wrong on my side since the installation should be working for most other people. Is it some Windows Setting issue? Am using it on WinXP. Thanks Jeff JJeff wrote: > > Thanks for your quick response, I have tried to re-install SQuirrel many > time. > > I forgot to state that I am using version 2.2 Final. I tried to uninstall > and reinstall 2.51, but the problem seemed get worse and I couldn't even > log in to any of my databases, hitting errors about user name and pasword > not matching even though SQLPlus had no problems with the username and > password. > > I since reverted back to ver 2.2 and trying to find a solution to the > problem. I will try again with the re-installation, but I am hoping for > another solution. > > Thanks. > > > > Gerd Wagner wrote: >> >> This looks much like a installation problem. It's pretty sure that it >> doesn't >> have anything to do with your DB connection. >> >> I'd simply try to reinstall SQuirreL. >> >> Gerd >> >> > > -- View this message in context: http://www.nabble.com/Error-in-Squirrel-when-connecting-to-Database-tf3807469.html#a10776611 Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
