• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Problem with PostgreSQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem with PostgreSQL

  • Subject: Re: Problem with PostgreSQL
  • From: Dev WO <email@hidden>
  • Date: Wed, 27 Nov 2013 11:00:51 +0100
Hello Bruno,

Does this line rings a bell?

Caused by: L'indice de la colonne est hors limite : 2, nombre de colonnes : 1.at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:57)

Just to make sure, you need at least:
-the pgsql plugin framework in the framework path in addition to the application path (if that's separate)
-you may need to fill the connection attributes in the EOModel for the PostgreSQL connection (like the name of the plugin as it may be different now)

Xavier

On 27 nov. 2013, at 10:51, "[Pyramide Ingenierie] WIESEN Bruno" <email@hidden> wrote:

Hello,

Recently we noticed really poor performance with PostgreSQL… We choose to try with PostgreSQLPlugin.framework from Project Wonder since we are still using a framework of 2006…
The problem is that it doesn’t work at all…

Here is the log…

I just replaced our old framework with the latest from project wonder…

com.webobjects.foundation.NSForwardException [java.lang.reflect.InvocationTargetException] null:java.lang.reflect.InvocationTargetException
[2013-11-27 10:49:3 CET] <WorkerThread0> com.webobjects.foundation.NSForwardException [java.lang.reflect.InvocationTargetException] null:java.lang.reflect.InvocationTargetException
at com.webobjects.foundation._NSUtilities._explainInstantiationException(_NSUtilities.java:626)
at com.webobjects.foundation._NSUtilities.instantiateObject(_NSUtilities.java:646)
at com.webobjects.appserver._private.WOComponentDefinition._componentInstanceInContext(WOComponentDefinition.java:544)
at com.webobjects.appserver._private.WOComponentDefinition.componentInstanceInContext(WOComponentDefinition.java:642)
at com.webobjects.appserver._private.WOComponentReference._pushComponentInContext(WOComponentReference.java:88)
at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:134)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136)
at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1122)
at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:135)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WOConditional.appendToResponse(WOConditional.java:94)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at er.ajax.AjaxUpdateContainer.appendToResponse(AjaxUpdateContainer.java:190)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136)
at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1122)
at Components.MainMenu.appendToResponse(MainMenu.java:40)
at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385)
at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:571)
at classes.CPUSession.appendToResponse(CPUSession.java:63)
at classes.Session.appendToResponse(Session.java:128)
at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:242)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:298)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332)
at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:369)
at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:442)
at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
at java.lang.Thread.run(Thread.java:695)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.webobjects.foundation._NSUtilities.instantiateObject(_NSUtilities.java:640)
... 30 more
Caused by: L'indice de la colonne est hors limite : 2, nombre de colonnes : 1.at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:57)
at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:121)
at org.postgresql.jdbc2.AbstractJdbc2Statement.bindString(AbstractJdbc2Statement.java:2112)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1238)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1224)
at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java:526)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:260)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
at com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1308)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
at Components.Menu_Customers.CustomerSelectList.listOfFoundCustomers(CustomerSelectList.java:255)
at Components.Menu_Customers.CustomerSelectList.actionSearchCustomers(CustomerSelectList.java:88)
at Components.Menu_Customers.CustomerSelectList.actionDefaultSearch(CustomerSelectList.java:81)
at Components.Menu_Customers.CustomerSelectList.<init>(CustomerSelectList.java:73)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.webobjects.foundation._NSUtilities.instantiateObject(_NSUtilities.java:640)
at com.webobjects.appserver._private.WOComponentDefinition._componentInstanceInContext(WOComponentDefinition.java:544)
at com.webobjects.appserver._private.WOComponentDefinition.componentInstanceInContext(WOComponentDefinition.java:642)
at com.webobjects.appserver._private.WOComponentReference._pushComponentInContext(WOComponentReference.java:88)
at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:134)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136)
at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1122)
at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:135)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WOConditional.appendToResponse(WOConditional.java:94)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at er.ajax.AjaxUpdateContainer.appendToResponse(AjaxUpdateContainer.java:190)
at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:126)
at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:136)
at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:1122)
at Components.MainMenu.appendToResponse(MainMenu.java:40)
at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385)
at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:571)
at classes.CPUSession.appendToResponse(CPUSession.java:63)
at classes.Session.appendToResponse(Session.java:128)
at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:242)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:298)
at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332)
at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:369)
at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:442)
at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
at java.lang.Thread.run(Thread.java:695)


at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java:650)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:260)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
at com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1308)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
at Components.Menu_Customers.CustomerSelectList.listOfFoundCustomers(CustomerSelectList.java:255)
at Components.Menu_Customers.CustomerSelectList.actionSearchCustomers(CustomerSelectList.java:88)
at Components.Menu_Customers.CustomerSelectList.actionDefaultSearch(CustomerSelectList.java:81)
at Components.Menu_Customers.CustomerSelectList.<init>(CustomerSelectList.java:73)
... 35 more




Best Regards,

Bruno WIESEN
..................................................................
Bruno WIESEN                               bruno.email@hidden

cipiyou,
Apple Premium Reseller division of
Pyramide Ingenierie sprl                  Tel:  +32 87 292120
83 Rue du brou                            Fax:  +32 87 292129
B-4800 Verviers                           Mail: email@hidden
..................................................................


<image001.jpg> Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Prev by Date: Re: Can someone please point me to sample ERQuartzScheduler code
  • Next by Date: Deploy on Ubuntu 13.10
  • Previous by thread: Re: Can someone please point me to sample ERQuartzScheduler code
  • Next by thread: Deploy on Ubuntu 13.10
  • Index(es):
    • Date
    • Thread