This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
khayati
Level 5
‎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
Labels (1)
Labels
0 Kudos

(5) Replies
RobertDickau
Flexera Alumni
‎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?
0 Kudos
khayati
Level 5
‎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
0 Kudos
khayati
Level 5
‎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.
0 Kudos
purcellk24
Level 7
‎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.
0 Kudos
khayati
Level 5
‎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 ?
0 Kudos