Hi. I need execute the command load (http://docs.openlinksw.com/virtuoso/isql.html) to load a sql dump.
from isql works fine isql> use test_scheme isql> load /var/folders/Lf/LfpHqngMENCf+2aAfoO3IE+++TI/-Tmp-/dump_sql_ext7446201432912089856tmp but from jdbc, I got the next exception: Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [load /var/folders/Lf/LfpHqngMENCf+2aAfoO3IE+++TI/-Tmp-/dump_sql_ext9081694128305764769tmp]; nested exception is virtuoso.jdbc4.VirtuosoException: SQ074: Line 1: syntax error at '/' before 'var' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at cl.toeska.cc.testing.ContentCompassITestsHelper$2.doInTransaction(ContentCompassITestsHelper.java:266) at cl.toeska.cc.testing.ContentCompassITestsHelper$2.doInTransaction(ContentCompassITestsHelper.java:1) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at cl.toeska.cc.testing.ContentCompassITestsHelper.executeQuery(ContentCompassITestsHelper.java:260) at cl.toeska.cc.lo_classifier.ExtectedLearningObjectServiceImplTest.loadDumpNN(ExtectedLearningObjectServiceImplTest.java:147) at cl.toeska.cc.lo_classifier.ExtectedLearningObjectServiceImplTest.setup(ExtectedLearningObjectServiceImplTest.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68) at org.ops4j.pax.exam.invoker.junit.internal.ContainerTestRunner.runChild(ContainerTestRunner.java:58) at org.ops4j.pax.exam.invoker.junit.internal.ContainerTestRunner.runChild(ContainerTestRunner.java:32) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222) at org.junit.runners.ParentRunner.run(ParentRunner.java:300) at org.junit.runner.JUnitCore.run(JUnitCore.java:157) at org.junit.runner.JUnitCore.run(JUnitCore.java:136) at org.ops4j.pax.exam.invoker.junit.internal.JUnitProbeInvoker.invokeViaJUnit(JUnitProbeInvoker.java:108) ... 21 more Caused by: virtuoso.jdbc4.VirtuosoException: SQ074: Line 1: syntax error at '/' before 'var' at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source) at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source) at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source) at virtuoso.jdbc4.VirtuosoStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 50 more i don't know if i have to escape character or what :( Best Regards! -- Marcelo Aliquintuy
