aspose file tools*
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
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Db2 SQL1109N error