473,248 Members | 1,169 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,248 software developers and data experts.

SQLJ - java.sql.SQLException: profile DimoiPolyInsert_SJProfile0 not found

I'm trying to insert large polygon data via sql statement. since the
data was over 32k I had to use sqlj to insert my data.

I made a class that inserts the data. ran sqlj, generated the .java
and .ser files then used
db2profc to bind the ser file.. not exacly 100% sure what this is
about.. but I kind of get the idea..

I imported the java file into my project and attempted to use it..

I'm initializing the class with:

Connection con = MyManager.getInstance().getConnection();
DimoiPolyInsert dpi = new DimoiPolyInsert(new
DefaultContext(con));

to set the default context.. then calling the insert function from
DimoiPolyInsert (the generated java file)

I get:

java.sql.SQLException: profile DimoiPolyInsert_SJProfile0 not found:
java.lang.ClassNotFoundException: DimoiPolyInsert_SJProfile0

What am I doing wrong? I'm guessing its looking for the .class of
the .ser file that was serialized? is this a file that should have
been generated?

any help please.. I'm lost with this one.

thank you!
Vasili
the results of the binding were:

C:\>db2profc -user myusr -password 12345 -url jdbc:db2://localhost:
50000/MYDB DimoiPolyInsert_SJProfile0.ser
[ibm][db2][jcc][sqlj]
[ibm][db2][jcc][sqlj] Begin Customization
[ibm][db2][jcc][sqlj] Loading profile: DimoiPolyInsert_SJProfile0
[ibm][db2][jcc][sqlj] Customization complete for profile
DimoiPolyInsert_SJProfile0.ser
[ibm][db2][jcc][sqlj] Begin Bind
[ibm][db2][jcc][sqlj] Loading profile: DimoiPolyInsert_SJProfile0
[ibm][db2][jcc][sqlj] Driver defaults(user may override): BLOCKING ALL
VALIDATE
BIND STATICREADONLY YES
[ibm][db2][jcc][sqlj] Fixed driver options: DATETIME ISO DYNAMICRULES
BIND
[ibm][db2][jcc][sqlj] Binding package DIMOIP01 at isolation level UR
[ibm][db2][jcc][sqlj] Binding package DIMOIP02 at isolation level CS
[ibm][db2][jcc][sqlj] Binding package DIMOIP03 at isolation level RS
[ibm][db2][jcc][sqlj] Binding package DIMOIP04 at isolation level RR
[ibm][db2][jcc][sqlj] Bind complete for DimoiPolyInsert_SJProfile0

Mar 31 '07 #1
1 3441

Starting to feel like there murphy's laws still apply here.. no matter
how long I've been trying to figure something out.. a soon as I ask a
question I find the answer.. apparantely theres a -ser2class option in
sqlj.. weird why this isn't by default.. what can you do with the ser
file without the class?

vasili
/ vasilip :
I'm trying to insert large polygon data via sql statement. since the
data was over 32k I had to use sqlj to insert my data.

I made a class that inserts the data. ran sqlj, generated the .java
and .ser files then used
db2profc to bind the ser file.. not exacly 100% sure what this is
about.. but I kind of get the idea..

I imported the java file into my project and attempted to use it..

I'm initializing the class with:

Connection con = MyManager.getInstance().getConnection();
DimoiPolyInsert dpi = new DimoiPolyInsert(new
DefaultContext(con));

to set the default context.. then calling the insert function from
DimoiPolyInsert (the generated java file)

I get:

java.sql.SQLException: profile DimoiPolyInsert_SJProfile0 not found:
java.lang.ClassNotFoundException: DimoiPolyInsert_SJProfile0

What am I doing wrong? I'm guessing its looking for the .class of
the .ser file that was serialized? is this a file that should have
been generated?

any help please.. I'm lost with this one.

thank you!
Vasili
the results of the binding were:

C:\>db2profc -user myusr -password 12345 -url jdbc:db2://localhost:
50000/MYDB DimoiPolyInsert_SJProfile0.ser
[ibm][db2][jcc][sqlj]
[ibm][db2][jcc][sqlj] Begin Customization
[ibm][db2][jcc][sqlj] Loading profile: DimoiPolyInsert_SJProfile0
[ibm][db2][jcc][sqlj] Customization complete for profile
DimoiPolyInsert_SJProfile0.ser
[ibm][db2][jcc][sqlj] Begin Bind
[ibm][db2][jcc][sqlj] Loading profile: DimoiPolyInsert_SJProfile0
[ibm][db2][jcc][sqlj] Driver defaults(user may override): BLOCKING ALL
VALIDATE
BIND STATICREADONLY YES
[ibm][db2][jcc][sqlj] Fixed driver options: DATETIME ISO DYNAMICRULES
BIND
[ibm][db2][jcc][sqlj] Binding package DIMOIP01 at isolation level UR
[ibm][db2][jcc][sqlj] Binding package DIMOIP02 at isolation level CS
[ibm][db2][jcc][sqlj] Binding package DIMOIP03 at isolation level RS
[ibm][db2][jcc][sqlj] Binding package DIMOIP04 at isolation level RR
[ibm][db2][jcc][sqlj] Bind complete for DimoiPolyInsert_SJProfile0
Apr 1 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: chaos | last post by:
Hello, i have problems using sqlj in the following environment. I use type 4 driver com.ibm.db2.jcc.DB2Driver and connect succesful to 8.1. db2-Database(DRDA)(Informational tokens are "DB2...
0
by: Bernard Dhooghe | last post by:
DB2 UDB V8.1 Fixpak 4 AIX 5.1 CLASSPATH: /usr/opt/db2_08_01/java/db2jcc.jar:/usr/opt/db2_08_01/java/db2jcc_license_cu.jar:/usr/opt/db2_08_01/java/sqlj.zip:/usr/java131/jre/lib/rt.jar: Program:...
10
by: Raquel | last post by:
UDB PE 8.1 on Win XP. ok, this function caused a lot of grief today. My stored procedures are java stored procedures, all FENCED and directly placed in \sqllib\function directory (not built into...
5
by: Raquel | last post by:
This is a very simple DB2 SQLJ stored procedure. The problem is that it seems to run fine but returns NOTHING. I mean..as if nothing has happened..not resultset is returned. I am passing value...
12
by: Rhino | last post by:
I am having an odd problem: the sqlj command on my system doesn't work. I am running DB2 (LUW) V8 (FP8) on WinXP. I haven't done an sqlj program since Version 6 of DB2 (LUW) so I checked the...
7
by: Jean-Marc Blaise | last post by:
Hi, The dev center calls sqlj.DB2_UPDATEJARINFO ('JMARC.JMB','JMB','file:JMB.sqlj') to update the sqlj routine source. I tried in CLP from the directory containing jar and sqlj files (Windows...
3
by: tol7481 | last post by:
Hi, I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box, but I have some problems. I've added to the classpath the following JARs sqllib/java/db2java.zip...
2
by: astolpho | last post by:
I am using a slightly outdated reference book on J2EE programming. It gives 2 methods of creating a database used in its casestudies. The first is an ANT script that gives the following output: ...
0
by: ajitkathar | last post by:
In my SQLJ procedure , there is call to another stored procedure using a callable statement. But during excecution when .excute() happens . . the DB2 V7 database shuts down. Plz help. Follwing...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.