SQLException with Portofino 4.2.1
96 views
Skip to first unread message
EvenAngel007
Feb 29, 2016, 6:54:44 PM2/29/16
to manydesigns-portofino
Hi all,
I just downloaded Portofino 4.2.1 and was very excited to use the REST API features. However, when I try the database wizard to connect to my oracle database, I am getting the below error.
Couldn't read schema names from db: java.sql.SQLException: Invalid column name
Below is the stack trace. Any help is greatly appreciated. Note that, to the same database, I was able to connect successfully using 4.1 beta 6. So, I am kind of went backwards trying to upgrade to 4.2.1
2016-02-29 18:46:36,178 INFO c.m.p.m.database.JdbcConnectionProvider admin /ac
tions/admin/wizard Added DECIMAL type as an alias of NUMERIC
2016-02-29 18:46:36,254 ERROR c.m.p.a.a.appwizard.ApplicationWizard admin /ac
tions/admin/wizard Couldn't read schema names from db
java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.jav
a:3711) ~[ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl
.java:2763) ~[ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:494
) ~[ojdbc6.jar:11.2.0.3.0]
at com.manydesigns.portofino.database.platforms.AbstractDatabasePlatform
.getSchemaNames(AbstractDatabasePlatform.java:138) ~[portofino-database-4.2.1.ja
r:4.2.1]
at com.manydesigns.portofino.database.platforms.OracleDatabasePlatform.g
etSchemaNames(OracleDatabasePlatform.java:71) ~[portofino-oracle-4.2.1.jar:4.2.1
]
at com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.c
onfigureEditSchemas(ApplicationWizard.java:358) [portofino-admin-4.2.1.jar:4.2.1
]
at com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.a
fterCreateConnectionProvider(ApplicationWizard.java:339) [portofino-admin-4.2.1.
jar:4.2.1]
at com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.c
onfigureConnectionProvider(ApplicationWizard.java:331) [portofino-admin-4.2.1.ja
r:4.2.1]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.
0_67]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57) ~[na:1.7.0_67]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43) ~[na:1.7.0_67]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]
at net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(Dispa
tcherHelper.java:456) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.ExecutionContext.proceed(Execution
Context.java:176) [stripes-1.6.0.jar:1.6.0]
at com.manydesigns.portofino.interceptors.GuardsInterceptor.intercept(Gu
ardsInterceptor.java:61) [portofino-base-4.2.1.jar:4.2.1]
at net.sourceforge.stripes.controller.ExecutionContext.proceed(Execution
Context.java:173) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.inter
cept(BeforeAfterMethodInterceptor.java:113) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.ExecutionContext.proceed(Execution
Context.java:173) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionCon
text.java:86) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandle
r(DispatcherHelper.java:454) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandl
er(DispatcherServlet.java:278) [stripes-1.6.0.jar:1.6.0]
at net.sourceforge.stripes.controller.DispatcherServlet.service(Dispatch
erServlet.java:160) [stripes-1.6.0.jar:1.6.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet
-api.jar:na]
at com.manydesigns.portofino.stripes.SimpleDynamicMappingFilter.doFilter
(SimpleDynamicMappingFilter.java:60) [portofino-stripes-4.2.1.jar:4.2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at com.manydesigns.portofino.servlets.I18nFilter.doFilter(I18nFilter.jav
a:60) [portofino-base-4.2.1.jar:4.2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilt
er.java:260) [stripes-1.6.0.jar:1.6.0]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at com.manydesigns.portofino.servlets.CleanupFilter.doFilter(CleanupFilt
er.java:46) [portofino-database-4.2.1.jar:4.2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at com.manydesigns.portofino.servlets.DispatcherFilter.doFilter(Dispatch
erFilter.java:61) [portofino-pageactions-4.2.1.jar:4.2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(Abstrac
tShiroFilter.java:449) [shiro-web-1.2.3.jar:1.2.3]
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiro
Filter.java:365) [shiro-web-1.2.3.jar:1.2.3]
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallab
le.java:90) [shiro-core-1.2.3.jar:1.2.3]
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable
.java:83) [shiro-core-1.2.3.jar:1.2.3]
at org.apache.shiro.subject.support.DelegatingSubject.execute(Delegating
Subject.java:383) [shiro-core-1.2.3.jar:1.2.3]
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(Abs
tractShiroFilter.java:362) [shiro-web-1.2.3.jar:1.2.3]
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerReq
uestFilter.java:125) [shiro-web-1.2.3.jar:1.2.3]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at com.manydesigns.elements.servlet.ElementsFilter.doHttpFilter(Elements
Filter.java:132) [elements-4.2.1.jar:4.2.1]
at com.manydesigns.elements.servlet.ElementsFilter.doFilter(ElementsFilt
er.java:83) [elements-4.2.1.jar:4.2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:239) [catalina.jar:8.0.30]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206) [catalina.jar:8.0.30]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:212) [catalina.jar:8.0.30]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:106) [catalina.jar:8.0.30]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:502) [catalina.jar:8.0.30]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:141) [catalina.jar:8.0.30]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:79) [catalina.jar:8.0.30]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcce
ssLogValve.java:616) [catalina.jar:8.0.30]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:88) [catalina.jar:8.0.30]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:521) [catalina.jar:8.0.30]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1096) [tomcat-coyote.jar:8.0.30]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:674) [tomcat-coyote.jar:8.0.30]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo
int.java:1500) [tomcat-coyote.jar:8.0.30]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoin
t.java:1456) [tomcat-coyote.jar:8.0.30]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145) [na:1.7.0_67]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615) [na:1.7.0_67]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61) [tomcat-util.jar:8.0.30]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]
Alessio Stalla
Mar 1, 2016, 5:19:55 AM3/1/16
to manydesign...@googlegroups.com
Hi,
there have been problems in the past with poor compatibility of Liquibase with Oracle (we use Liquibase inside Portofino). Can you tell me what version of Oracle are you connecting to and which JDBC driver version are you using?--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.
To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.
To post to this group, send email to manydesign...@googlegroups.com.
Visit this group at https://groups.google.com/group/manydesigns-portofino.
For more options, visit https://groups.google.com/d/optout.
Even Angel
Mar 1, 2016, 1:38:24 PM3/1/16
to manydesigns-portofino
Hi Alessio,
Thank you for your response.
The Oracle database version is 11g Enterprise Edition Release 11.2.0.4.0 - 64 bit.
The JDBC Driver Version is 11.2.0.3.0.
Thanks much for your help.
Regards.
To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-portofino+unsub...@googlegroups.com.
shiv...@gmail.com
Aug 4, 2016, 9:30:59 PM8/4/16
to manydesigns-portofino, adit...@gmail.com
Faced exactly same issue. Is there a list of supported databases and their versions ? It would be far easier to test the product features with a database/version is certified to work with.
Reply all
Reply to author
Forward
0 new messages