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