Hi David,
What version of the JDK does Coldfusion use as virtjdbc2.jar is for
JDBC 2.0 used by JDKs 1.2 & 1.3, whereas virtjdbc3.jar is for JDBC
3.0 used by JDK 1.4 & 1.5 ( and compatible with JDK 1.6) ? I would
have thought Coldfusion is using something greater than JDK 1.4 at
least thus virtjdbc3.jar is what you should be using ie copy to the
CF classpath and remove the virtjdbc2.jar from that location.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 24 Dec 2008, at 17:06, David Benge wrote:
Yea, the first one is going in fine then it hangs. If I comment
the SQL insert the loop runs all 50 so that is working. I looked
in the Coldfusion server logs and did not find anything at all.
I was trying both with and without ; on the query.
Yea, that version info is weird. I did remove 5.0.8 and installed
5.0.9 so I am not sure why its reporting the wrong version.
In CF you have a class path and you just put the jdbc libraries
there and all is good. I currently have only virtjdbc2.jar in the
lib directory for CF.
On 12/24/08 1:59 AM, "Hugh Williams" <hwilli...@openlinksw.com> wrote:
Hi David,
What is the insert query that is actually failing or causing the
hang, as looking at the server log you provide the only insert
query I see that has failed from the server log is:
09:52:03 CSLQ_0 dba 10.7.241.250 1111:29 s8259 INSERT INTO
KITN.OPENSOCIAL.PERSON
(KITNUSER_ID,PERSON_ID,ID,FIRST_NAME,LAST_NAME) VALUES
(710,'inactv1770','inactv1770','Wee Ling','Tan');
09:52:03 COMP_2 dba 10.7.241.250 1111:29 Compile text: INSERT INTO
KITN.OPENSOCIAL.PERSON
(KITNUSER_ID,PERSON_ID,ID,FIRST_NAME,LAST_NAME) VALUES
(710,'inactv1770','inactv1770','Wee Ling','Tan');
09:52:03 ERRS_0 37000 SQ074 Line 1: syntax error
Which is then immediately corrected with the ";" being removed and
is then successful:
09:52:37 CSLQ_0 dba 10.7.241.250 1111:29 s8260 INSERT INTO
KITN.OPENSOCIAL.PERSON
(KITNUSER_ID,PERSON_ID,ID,FIRST_NAME,LAST_NAME) VALUES
(710,'inactv1770','inactv1770','Wee Ling','Tan')
09:52:37 COMP_2 dba 10.7.241.250 1111:29 Compile text: INSERT INTO
KITN.OPENSOCIAL.PERSON
(KITNUSER_ID,PERSON_ID,ID,FIRST_NAME,LAST_NAME) VALUES
(710,'inactv1770','inactv1770','Wee Ling','Tan')
09:52:37 EXEC_1 dba 10.7.241.250 1111:29 s8260 Exec 1 time(s)
INSERT INTO KITN.OPENSOCIAL.PERSON
(KITNUSER_ID,PERSON_ID,ID,FIRST_NAME,LAST_NAME) VALUES
(710,'inactv1770','inactv1770','Wee Ling','Tan')
Also, you state that you virtuoso version is "Version 5.0.8.3035-
threads as of Nov 5 2008" but when I look in the server log for
the actual running instance I see:
15:48:58 Version 05.09.3035-threads for Win32 as of Nov 5 2008
So you are running the latest 5.09 release.
How did the Virtuoso JDBC driver virtjdbc.jar get in your
application server presumably you copied it their some how from the
distribution, so their must be a copy you can get the version of by
adding it to your classpath, you will also need it their for the
JDBCDemo program to locate it.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 23 Dec 2008, at 18:33, David Benge wrote:
I have included the details you asked for. Its acting differently
today than it was. I can get the first record to insert but then
the app hangs.
I can Query ( SELECT ) and I can CALL procs.
BTW thanks for your help!
________________________________
From: Hugh Williams [mailto:hwilli...@openlinksw.com]
Sent: Monday, December 22, 2008 12:47 PM
To: David Benge
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] virtuoso JDBC connection help
Hi David,
Can you please provide the following;
1. The Virtuoso of the Virtuoso server in use , type "virtuoso-t
-?" to get the version details.
Virtuoso Open Source Edition (multi threaded)
Version 5.0.8.3035-threads as of Nov 5 2008
Compiled for 32 Bit Windows Operating Environments
Copyright (C) 1999-2008 OpenLink Software
2. The JDBC Driver version, type "java virtuoso.jdbc3.Driver".
The jars are in the application server and not in the java home.
3. The exact error being returned, or is it just "-8" .
That is what I am getting back from the coldfusion server.
VENDORERRORCODE -8
And now it appears to be hanging indefinably waiting for a response
from the insert.
4. A copy of your Virtuoso Server log "virtuoso.log" so we can see
if any errors are occurring in it.
attached.
5. Turn on tracing in the Virtuoso server as detailing in the
following documentation such that we can see what SQL is being sent
to the server:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html#
(NULL)
The tracing will be writtent to the "virtuoso.log" file requested
in step 4.
Note we do provide a JDBCDemo sample program shipped with the open
source version which you can also run to determine if the same
query can be executed with the JDBC driver without Coldfusion in
the mix:
I will try that out but the first query seems to be working. I am
looping over data from an Oracle db and inserting into OV.
$ find . -name JDBCDemo.class -print
./binsrc/samples/JDBC/jdk1.1/JDBCDemo/JDBCDemo.class
./binsrc/samples/JDBC/jdk1.2/JDBCDemo/JDBCDemo.class
./binsrc/samples/JDBC/jdk1.3/JDBCDemo/JDBCDemo.class
./binsrc/samples/JDBC/jdk1.4/JDBCDemo/JDBCDemo.class
./binsrc/samples/JDBC/jdk1.5/JDBCDemo/JDBCDemo.class
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 22 Dec 2008, at 17:36, David Benge wrote:
I need to tie our db that is in the virtuoso server into our
Coldfusion J2ee server via JDBC. I can load the JDBC driver and
make selects all day long but when I try an Insert I get syntax
error message -8. I can take the same Insert statement to ISQL or
the web console and it works fine.
I could use some tips on either what I am doing wrong or where I
can find more debug logging information to help me figure out what
is going wrong.
Thanks
----------------------------------------------------------------------
--------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
<virtuoso.log>
