• 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: Newbie web services with WO question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Newbie web services with WO question

  • Subject: Re: Newbie web services with WO question
  • From: "Luigi Giannini" <email@hidden>
  • Date: Thu, 25 May 2006 22:07:02 +0200
2006/5/25, Chuck Hill <email@hidden>: 

On May 25, 2006, at 12:30 PM, Luigi Giannini wrote:

> Yes I have a EO_PK_TABLE.
> What is the function of this table?
It is what EOF uses to generate primary key values when the database
does not provide usable, native support.


> Where I can read about it from a more technical point of view?
>
If you search on Apple's site, you can find some mention of it.
Usually  all you have to do is to not delete it.  :-)


> I have modelled the primary key for PazientiAnagrafica entity with
> following attributes:
> - "Allows null" set to no
> - "Class property" set to no
> - "Locking" set to yes
> - "External Type" set to int
> - "Width" set to 4
>
Width is for strings, leave this blank.
Done 


> - "Value class java" set to number
> - "Value Type" set to i
> for "External Type" I try different values with no success within some
> (but not all) of these:
> - uniqueidentifier
> - tinyint identity
> - smallint identity
> - numeric() identity
> - decimal() identity
> - bigint identity
>
It is difficult to use identity columns with EOF.  You should avoid
them.  Just make the column int or bigint or something like that and
EOF will make sure the PK gets generated.


> And I not find nothing about the right choose about "External Type"
> setting when the fields in DB is the primary key.

Numeric, int, bigint should all be fine. 

Done. set to int




> Moreover I want
> specify that the attributes in MSSQL table for this field are normal:
> Data type=int ; Lenght=4 ; Allows null=no.
> Is clear also for a newbie like me that the error depends by a JDBC
> problem but, without the someone else help, I have no chance.
> In the technical specifications of official Apple WebObjects web site
> you can read that Microsoft SQL Server 2000 8.00.194 is supported.
> Where one newbie WOdeveloper can find jdbc for this RDBMS?
> I search in the web and find JTDS jdbc that seem (to me) a valid,
> mature and fast jdbc driver for MS-sql-srv.
> May be that the jdbc driver generate the problem but if so, please,

It may be that driver. Can you post the entire stack trace? 

Please be patient: what you mean with 'stack trace'?
Below there's the Xcode Run Log (I hope is what you ask ...):

java.lang.IllegalStateException: Adaptor
com.webobjects.jdbcadaptor.JDBCAdaptor@538b14 failed to provide new
primary keys for entity 'PazientiAnagrafica'
	at com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator(EODatabaseContext.java:5885)
	at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:409)
	at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3226)
	at com.webobjects.webservices.generation.WOOperation.saveChangesInEditingContext(WOOperation.java:96)
	at com.webobjects.webservices.generation.WOInsertOperation.invoke(WOInsertOperation.java:63)
	at com.webobjects.webservices.generation.WOOperation._invoke(WOOperation.java:120)
	at com.webobjects.webservices.generation._WSRuleUtilities.invokeOperationOnService(_WSRuleUtilities.java:208)
	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:585)
	at com.webobjects.appserver._private.WORPCProvider.processMessage(WORPCProvider.java:351)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
	at com.webobjects.appserver._private.WOWebService.performActionNamed(WOWebService.java:375)
	at com.webobjects.appserver._private.WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:240)
	at com.webobjects.appserver._private.WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:142)
	at com.webobjects.appserver._private.WOWebServiceRequestHandler.handleRequest(WOWebServiceRequestHandler.java:95)
	at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1306)[2006-05-25
21:47:45 CEST] <WorkerThread9> AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.lang.IllegalArgumentException:
java.lang.IllegalStateException: Adaptor
com.webobjects.jdbcadaptor.JDBCAdaptor@538b14 failed to provide new
primary keys for entity &apos;PazientiAnagrafica&apos;
faultActor:
faultNode:
faultDetail:
	{http://xml.apache.org/axis/}stackTrace:
java.lang.IllegalArgumentException: java.lang.IllegalStateException:
Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@538b14 failed to
provide new primary keys for entity 'PazientiAnagrafica'
	at com.webobjects.webservices.generation._WSRuleUtilities.invokeOperationOnService(_WSRuleUtilities.java:212)
	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.j
	at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
	at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
	at java.lang.Thread.run(Thread.java:613)
ava:585)
	at com.webobjects.appserver._private.WORPCProvider.processMessage(WORPCProvider.java:351)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
	at com.webobjects.appserver._private.WOWebService.performActionNamed(WOWebService.java:375)
	at com.webobjects.appserver._private.WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:240)
	at com.webobjects.appserver._private.WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:142)
	at com.webobjects.appserver._private.WOWebServiceRequestHandler.handleRequest(WOWebServiceRequestHandler.java:95)
	at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1306)
	at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
	at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
	at java.lang.Thread.run(Thread.java:613)


java.lang.IllegalArgumentException: java.lang.IllegalStateException:
Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@538b14 failed to
provide new primary keys for entity 'PazientiAnagrafica'
	at org.apache.axis.AxisFault.makeFault(AxisFault.java:129)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:343)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
	at com.webobjects.appserver._private.WOWebService.performActionNamed(WOWebService.java:375)
	at com.webobjects.appserver._private.WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:240)
	at com.webobjects.appserver._private.WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:142)
	at com.webobjects.appserver._private.WOWebServiceRequestHandler.handleRequest(WOWebServiceRequestHandler.java:95)
	at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1306)
	at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
	at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
	at java.lang.Thread.run(Thread.java:613)
Caused by: java.lang.IllegalArgumentException:
java.lang.IllegalStateException: Adaptor
com.webobjects.jdbcadaptor.JDBCAdaptor@538b14 failed to provide new
primary keys for entity 'PazientiAnagrafica'
	at com.webobjects.webservices.generation._WSRuleUtilities.invokeOperationOnService(_WSRuleUtilities.java:212)
	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:585)
	at com.webobjects.appserver._private.WORPCProvider.processMessage(WORPCProvider.java:351)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
	... 13 more


Many thanks Chuck


Luigi Giannini
_______________________________________________
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




  • Follow-Ups:

      

    • Re: Newbie web services with WO question

      • From: Chuck Hill <email@hidden>
      • 





References: 


 >Newbie web services with WO question (From: "Luigi Giannini" <email@hidden>)


 >Re: Newbie web services with WO question (From: Chuck Hill <email@hidden>)


 >Re: Newbie web services with WO question (From: "Luigi Giannini" <email@hidden>)


 >Re: Newbie web services with WO question (From: Chuck Hill <email@hidden>)






    

  • Prev by Date:
Re: Newbie web services with WO question

    • 

  • Next by Date:
Re: Newbie web services with WO question

    • 

  • Previous by thread:
Re: Newbie web services with WO question

    • 

  • Next by thread:
Re: Newbie web services with WO question

    • 

  • Index(es):

      

    • Date
      • 

    • Thread
      • 

    

    •