{"action":"created","issue":{"url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/25","repository_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc","labels_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/25/comments","events_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/25/events","html_url":"https://github.com/zsoltherpai/fluent-jdbc/issues/25","id":151468855,"number":25,"title":"Oracle 11g is throwing exception with getGeneratedKeys","user":{"login":"sachinwalia2k8","id":2308115,"avatar_url":"https://avatars.githubusercontent.com/u/2308115?v=3","gravatar_id":"","url":"https://api.github.com/users/sachinwalia2k8","html_url":"https://github.com/sachinwalia2k8","followers_url":"https://api.github.com/users/sachinwalia2k8/followers","following_url":"https://api.github.com/users/sachinwalia2k8/following{/other_user}","gists_url":"https://api.github.com/users/sachinwalia2k8/gists{/gist_id}","starred_url":"https://api.github.com/users/sachinwalia2k8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sachinwalia2k8/subscriptions","organizations_url":"https://api.github.com/users/sachinwalia2k8/orgs","repos_url":"https://api.github.com/users/sachinwalia2k8/repos","events_url":"https://api.github.com/users/sachinwalia2k8/events{/privacy}","received_events_url":"https://api.github.com/users/sachinwalia2k8/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"zsoltherpai","id":2029253,"avatar_url":"https://avatars.githubusercontent.com/u/2029253?v=3","gravatar_id":"","url":"https://api.github.com/users/zsoltherpai","html_url":"https://github.com/zsoltherpai","followers_url":"https://api.github.com/users/zsoltherpai/followers","following_url":"https://api.github.com/users/zsoltherpai/following{/other_user}","gists_url":"https://api.github.com/users/zsoltherpai/gists{/gist_id}","starred_url":"https://api.github.com/users/zsoltherpai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zsoltherpai/subscriptions","organizations_url":"https://api.github.com/users/zsoltherpai/orgs","repos_url":"https://api.github.com/users/zsoltherpai/repos","events_url":"https://api.github.com/users/zsoltherpai/events{/privacy}","received_events_url":"https://api.github.com/users/zsoltherpai/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/milestones/12","html_url":"https://github.com/zsoltherpai/fluent-jdbc/milestones/1.2","labels_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/milestones/12/labels","id":1735035,"number":12,"title":"1.2","description":null,"creator":{"login":"zsoltherpai","id":2029253,"avatar_url":"https://avatars.githubusercontent.com/u/2029253?v=3","gravatar_id":"","url":"https://api.github.com/users/zsoltherpai","html_url":"https://github.com/zsoltherpai","followers_url":"https://api.github.com/users/zsoltherpai/followers","following_url":"https://api.github.com/users/zsoltherpai/following{/other_user}","gists_url":"https://api.github.com/users/zsoltherpai/gists{/gist_id}","starred_url":"https://api.github.com/users/zsoltherpai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zsoltherpai/subscriptions","organizations_url":"https://api.github.com/users/zsoltherpai/orgs","repos_url":"https://api.github.com/users/zsoltherpai/repos","events_url":"https://api.github.com/users/zsoltherpai/events{/privacy}","received_events_url":"https://api.github.com/users/zsoltherpai/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2016-04-27T21:06:46Z","updated_at":"2016-04-27T23:58:12Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2016-04-27T19:19:23Z","updated_at":"2016-04-27T23:58:12Z","closed_at":"2016-04-27T23:58:12Z","body":"I am working on migrating a project from mysql to Oracle. Fluent Jdbc is throwing exception when trying to retrieve generated primary key using sequence. Here are the details:\r\n\r\nJava Code:\r\n\r\n```\r\nString sql = \"INSERT INTO test_table (test_id, test_token, test_name, create_time) VALUES (TEST_SEQ.nextval, :testToken, :testName, :createTime)\";\r\nQuery query = fluentJdbc.query();\r\nMap<String, Object> params = new HashMap<>();\r\nparams.put(\"testToken\", testToken);\r\nparams.put(\"testName\", testName);\r\nparams.put(\"createTime\", new Date());\r\nUpdateResultGenKeys<Integer> result = query.update(sql).namedParams(params).runFetchGenKeys(Mappers.singleInteger());\r\nreturn result.generatedKeys().get(0);\t\t\r\n```\r\n\r\nException trace:\r\n\r\n```\r\n\r\nCaused by: org.codejargon.fluentjdbc.api.FluentJdbcSqlException: Error running query, INSERT INTO test_table\r\n (test_id, test_token, test_name, create_time)\r\nVALUES (TEST_SEQ.nextval, :testToken, :testName, :createTime)\r\n\tat org.codejargon.fluentjdbc.internal.query.QueryInternal.queryException(QueryInternal.java:86)\r\n\tat org.codejargon.fluentjdbc.internal.query.QueryInternal.query(QueryInternal.java:73)\r\n\tat org.codejargon.fluentjdbc.internal.query.SingleQueryBase.runQuery(SingleQueryBase.java:52)\r\n\tat org.codejargon.fluentjdbc.internal.query.SingleQueryBase.runQueryAndFetch(SingleQueryBase.java:46)\r\n\tat org.codejargon.fluentjdbc.internal.query.UpdateQueryInternal.runFetchGenKeys(UpdateQueryInternal.java:28)\r\n\tat org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:483)\r\n\tat org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\r\n\tat org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)\r\n\tat org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)\r\n\tat org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)\r\n\tat org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)\r\n\tat org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n\tat org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)\r\n\tat org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)\r\n\tat org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)\r\n\t... 56 common frames omitted\r\nCaused by: java.sql.SQLException: Invalid column type: getInt not implemented for class oracle.jdbc.driver.T4CRowidAccessor\r\n\tat oracle.jdbc.driver.Accessor.unimpl(Accessor.java:412)\r\n\tat oracle.jdbc.driver.Accessor.getInt(Accessor.java:529)\r\n\tat oracle.jdbc.driver.OracleReturnResultSet.getInt(OracleReturnResultSet.java:388)\r\n\tat org.codejargon.fluentjdbc.api.mapper.Mappers.lambda$static$21(Mappers.java:12)\r\n\tat org.codejargon.fluentjdbc.api.mapper.Mappers$$Lambda$61/1147609543.map(Unknown Source)\r\n\tat org.codejargon.fluentjdbc.internal.query.UpdateQueryInternal.generatedKeys(UpdateQueryInternal.java:69)\r\n\tat org.codejargon.fluentjdbc.internal.query.UpdateQueryInternal.lambda$runFetchGenKeys$39(UpdateQueryInternal.java:31)\r\n\tat org.codejargon.fluentjdbc.internal.query.UpdateQueryInternal$$Lambda$66/1901855472.run(Unknown Source)\r\n\tat org.codejargon.fluentjdbc.internal.query.SingleQueryBase.lambda$runQuery$3(SingleQueryBase.java:54)\r\n\tat org.codejargon.fluentjdbc.internal.query.SingleQueryBase$$Lambda$49/345155581.run(Unknown Source)\r\n\tat org.codejargon.fluentjdbc.internal.integration.QueryConnectionReceiverInternal.receive(QueryConnectionReceiverInternal.java:19)\r\n\tat org.codejargon.fluentjdbc.api.integration.providers.DataSourceConnectionProvider.provide(DataSourceConnectionProvider.java:23)\r\n\tat org.codejargon.fluentjdbc.internal.query.QueryInternal.doQuery(QueryInternal.java:93)\r\n\tat org.codejargon.fluentjdbc.internal.query.QueryInternal.query(QueryInternal.java:61)\r\n\t... 83 common frames omitted\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/comments/215267921","html_url":"https://github.com/zsoltherpai/fluent-jdbc/issues/25#issuecomment-215267921","issue_url":"https://api.github.com/repos/zsoltherpai/fluent-jdbc/issues/25","id":215267921,"user":{"login":"sachinwalia2k8","id":2308115,"avatar_url":"https://avatars.githubusercontent.com/u/2308115?v=3","gravatar_id":"","url":"https://api.github.com/users/sachinwalia2k8","html_url":"https://github.com/sachinwalia2k8","followers_url":"https://api.github.com/users/sachinwalia2k8/followers","following_url":"https://api.github.com/users/sachinwalia2k8/following{/other_user}","gists_url":"https://api.github.com/users/sachinwalia2k8/gists{/gist_id}","starred_url":"https://api.github.com/users/sachinwalia2k8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sachinwalia2k8/subscriptions","organizations_url":"https://api.github.com/users/sachinwalia2k8/orgs","repos_url":"https://api.github.com/users/sachinwalia2k8/repos","events_url":"https://api.github.com/users/sachinwalia2k8/events{/privacy}","received_events_url":"https://api.github.com/users/sachinwalia2k8/received_events","type":"User","site_admin":false},"created_at":"2016-04-27T23:58:12Z","updated_at":"2016-04-27T23:58:12Z","body":"@zsoltherpai - just tested. Works great. "}}