During my creation of a new datasource connecting to Sybase, I got an error:
OpenReport Error:
could not insert:[org.efs.openreports.objects.ReportDataSource]
In Tomcat:
--------------------------
18:35:10,304 INFO MailProvider - Created
18:35:12,383 INFO DataSourcePersistenceProvider - DataSourcePersistenceProvider Created.
18:35:12,414 INFO DataSourceProviderImpl - DataSourceProviderImpl
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: -11, SQLState: 37000
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: -11, SQLState: 37000
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
Mar 29, 2006 6:36:09 PM net.sf.hibernate.JDBCException <init>
SEVERE: could not insert: [org.efs.openreports.objects.ReportDataSource]
java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:541)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432)
at net.sf.hibernate.impl.ScheduledIdentityInsertion.execute(ScheduledIdentityInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:906)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:839)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:757)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720)
at org.efs.openreports.providers.persistence.HibernateProvider.save(HibernateProvider.java:99)
at org.efs.openreports.providers.persistence.DataSourcePersistenceProvider.insertDataSource(DataSourcePersistenceProvider.java:58)
at org.efs.openreports.providers.impl.DataSourceProviderImpl.insertDataSource(DataSourceProviderImpl.java:119)
at org.efs.openreports.actions.admin.EditDataSourceAction.execute(EditDataSourceAction.java:113)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
at org.efs.openreports.interceptors.SecurityInterceptor.intercept(SecurityInterceptor.java:56)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:280)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:250)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
18:36:09,494 ERROR EditDataSourceAction - org.efs.openreports.providers.ProviderException: could not insert: [org.efs.openreports.objects.ReportDataSource]
--------------------------
Here's the info. I put this info during Data Source Definition:
Hi there,
During my creation of a new datasource connecting to Sybase, I got an error:
OpenReport Error:
could not insert:[org.efs.openreports.objects.ReportDataSource]
In Tomcat:
--------------------------
18:35:10,304 INFO MailProvider - Created
18:35:12,383 INFO DataSourcePersistenceProvider - DataSourcePersistenceProvider Created.
18:35:12,414 INFO DataSourceProviderImpl - DataSourceProviderImpl
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: -11, SQLState: 37000
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: -11, SQLState: 37000
Mar 29, 2006 6:36:09 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
Mar 29, 2006 6:36:09 PM net.sf.hibernate.JDBCException <init>
SEVERE: could not insert: [org.efs.openreports.objects.ReportDataSource]
java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:541)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432)
at net.sf.hibernate.impl.ScheduledIdentityInsertion.execute(ScheduledIdentityInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:906)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:839)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:757)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720)
at org.efs.openreports.providers.persistence.HibernateProvider.save(HibernateProvider.java:99)
at org.efs.openreports.providers.persistence.DataSourcePersistenceProvider.insertDataSource(DataSourcePersistenceProvider.java:58)
at org.efs.openreports.providers.impl.DataSourceProviderImpl.insertDataSource(DataSourceProviderImpl.java:119)
at org.efs.openreports.actions.admin.EditDataSourceAction.execute(EditDataSourceAction.java:113)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
at org.efs.openreports.interceptors.SecurityInterceptor.intercept(SecurityInterceptor.java:56)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:280)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:250)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.opensymphony.webwork.lifecycle.RequestLifecycleFilter.doFilter(RequestLifecycleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
18:36:09,494 ERROR EditDataSourceAction - org.efs.openreports.providers.ProviderException: could not insert: [org.efs.openreports.objects.ReportDataSource]
--------------------------
Here's the info. I put this info during Data Source Definition:
URL: jdbc:sybase:Tds:<IP>:<port>/?charset=iso_1
Driver: com.sybase.jdbc2.jdbc.SybDriver
I included the ?charset=iso_1 since our DB needs it.
It's been working (URL) with iReport wherein I'm using to generete *.jasper.
Thanks.
Jun
Can you create other records such as new users? Did you update the dialect in hibernate.properties?
- Erik