Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Db2 SQL1109N error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Db2 SQL1109N error" Watch "Db2 SQL1109N error" New topic
Author

Db2 SQL1109N error

vikram nalagampalli
Ranch Hand

Joined: Oct 08, 2001
Posts: 91
Hi all,
I am trying to connect to an remote database server norder to acess as tored procedure.
I configured an Db2 client on my M/c to talk to the remote server. Connection came out to be sucessful but then i am gettign the following error. Can any one help me with this.

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1109N The specified
DLL "Insert_OIG_SSNs.insert_OIG_SSNs" could not be loaded.
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExce
ptionGenerator.java:270)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExce
ptionGenerator.java:207)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep
tionGenerator.java:458)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStateme
nt.java:2110)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatemen
t.java:3887)
at OigMQ.insertSSN(OigMQ.java:175)
at OigMQ.main(OigMQ.java:55)

Thank you
Regards,
Vikram
Chetan M
Ranch Hand

Joined: Dec 18, 2002
Posts: 43
Hi Vikram,
Just check out the links below.. hope are of help to u..
http://www-3.ibm.com/cgi-bin/db2www...upport/document.d2w/report?fn=db2l088.htm
https://aurora.vcu.edu/db2help/db2p0/frame3.htm#clitips
http://www.ibm.com/Search?v=11&lang=en&cc=us&q=SQL1109N
#####################################################
HAKUNAMATATA!!!


No matter how much you know today, you will have to know more tomorrow.<br /> Hakunamatata !!!
Karthi Bala
Ranch Hand

Joined: Jul 27, 2001
Posts: 48
Ciao,
The problem can be resolved in case of Java Stored Procedures by placing the .class files in the <DB2INSTALL>\sqllib\function folder.
Karthi.


Karthi Bala<br />SCJP 1.2, SCWCD 1.3, SCWCD 1.4, SCDJWS (Awaiting Result)<br /> <br />Where there is a will,there is a WAY.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Db2 SQL1109N error
 
Similar Threads
SQLSTATE=22005 WebSphere 5.1.1.3 and db2 7.x
DB2 App Driver gives Null Pointer
DB2 StaleConnectionException
Special character handling
WAS 4.0.5 DB2 7.2 (NT) connection