This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: No Suitable driver found error in custom code
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
02:36 PM
No Suitable driver found error in custom code
Hi
I have a custom code which is using a java.sql.getConnection menthod() to call db2 connection .Wwhile using this method i m gettng No suitable driver found error.My installer is using the Java 142 which is sucessfully used by my ISMP installer
Can any pone help?
Is my IA taking some internal java with it.
The log file shows the system java only
I have a custom code which is using a java.sql.getConnection menthod() to call db2 connection .Wwhile using this method i m gettng No suitable driver found error.My installer is using the Java 142 which is sucessfully used by my ISMP installer
Can any pone help?
Is my IA taking some internal java with it.
The log file shows the system java only
(5) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
03:48 PM
I don't have first-hand experience with this, but what did the working ISMP code look like? What does the equivalent IA custom code look like?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 12, 2008
09:32 AM
well the menthod which is actually throwing this exception is actually the sql java method to get the connection and this inturns gets called in my methos
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 14, 2008
08:56 AM
Can you tell me which java is used while trying to make a connection to DB2.Actually i have set my Java_home path and haev included the installable as "Dont install the VM".so by default it should as is picking my JAVA_HOME path.But dnt know y when creating a connection with DB it throws "no suitable driver excpetion".
All appl are running jst fyn with this JAVA_HOME and have been using DB2.My guess is tht that IA might be intermigling with the system's java or something is rrestricting to access DB2.
All appl are running jst fyn with this JAVA_HOME and have been using DB2.My guess is tht that IA might be intermigling with the system's java or something is rrestricting to access DB2.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 14, 2008
12:21 PM
In your call to execute the custom code, make sure you have your db2 driver jar file listed as a dependency.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 15, 2008
01:32 PM
Hi Thanks for the reply...I think i was missing this key thing .Do i have to include IA specific DB2 Drivers ?Because i used the drivers which my application is using and also as mentioned by u ,included in my code....but stil i m facing this issue [:(].Its been too long since i m stuck with this problem and not able to find the workaround for this .
With this effect i changed the drivers my application was using from Type 2 -> Type 4 and executed my application but not i am running into diff set of exception - > com.ibm.db2.jcc.b.SqlException: IO Exception opening socket to server sdwbrh9.in.ibm.com on port 60001. The DB2 Server may be down.
at com.ibm.db2.jcc.a.a.(a.java:137)
at com.ibm.db2.jcc.a.b.a(b.java:1542)
at com.ibm.db2.jcc.b.o.(o.java:795)
at com.ibm.db2.jcc.a.b.(b.java:298)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at com.ibm.eReview.server.install.InstallType.getConnection1(InstallType.java:187)
at com.ibm.eReview.server.install.InstallType.getConnection(InstallType.java:107)
at com.ibm.eReview.server.install.InstallType.install(InstallType.java:46)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGab8.run(DashoA10*..)
I have chlked the db2port and is set properly.What should i do ?
With this effect i changed the drivers my application was using from Type 2 -> Type 4 and executed my application but not i am running into diff set of exception - > com.ibm.db2.jcc.b.SqlException: IO Exception opening socket to server sdwbrh9.in.ibm.com on port 60001. The DB2 Server may be down.
at com.ibm.db2.jcc.a.a.
at com.ibm.db2.jcc.a.b.a(b.java:1542)
at com.ibm.db2.jcc.b.o.
at com.ibm.db2.jcc.a.b.
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at com.ibm.eReview.server.install.InstallType.getConnection1(InstallType.java:187)
at com.ibm.eReview.server.install.InstallType.getConnection(InstallType.java:107)
at com.ibm.eReview.server.install.InstallType.install(InstallType.java:46)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGab8.run(DashoA10*..)
I have chlked the db2port and is set properly.What should i do ?
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)