Hi Enric, I just came across some links from PostgreSQL, relevant to the exception mentioned earlier -
Exception in thread "main" *java.lang.RuntimeException*: * org.postgresql.util.PSQLException*: Returning autogenerated keys is not supported.
[1]http://gborg.postgresql.org/project/pgjdbc/bugs/bugupdate.php?984 [2]http://archives.postgresql.org/pgsql-jdbc/2007-02/msg00074.php Seems from [2] that, there is some progress on that front. Regards, Amita On 7/9/07, Enric Staromiejski Torregrosa <[EMAIL PROTECTED]> wrote:
I'll be absent for three or four days, but i'll try it when i'll be back. Thanks for the effort. Enric 2007/7/9, Luciano Resende <[EMAIL PROTECTED]>: > > Hi Enric > > I was chatting with Amita about this problem, and she found that > this might be a problem on our code, I have applied a fix for the > issue to trunk under revision #554549. Please let us know if that > helps. > > On 7/6/07, Enric Staromiejski Torregrosa <[EMAIL PROTECTED]> > wrote: > > BTW, did you solve this problem with Oracle? We optionally are allowed > to > > use Oracle instead of PostgreSQL... > > > > Regards > > > > > > 2007/7/5, Luciano Resende <[EMAIL PROTECTED]>: > > > > > > This might be the same issue we have with the Oracle JDBC drive, could > > > you try specifying the resultset shape definition in the das config as > > > described in this user's guide link [1] and see if this make you go > > > further ? > > > > > > [1] > > > > http://cwiki.apache.org/confluence/display/TUSCANY/Explicit+ResultSet+shape+definition > > > > > > On 7/5/07, Enric Staromiejski Torregrosa < [EMAIL PROTECTED]> > > > wrote: > > > > Luciano, > > > > > > > > when configuring the Customer sample against mysql everything goes > fine. > > > The > > > > PostgreSQL connection and table creation also works fine, but the > SELECT > > > > sentence reports back the following exception: > > > > > > > > Exception in thread "main" *java.lang.RuntimeException*: * > > > > org.postgresql.util.PSQLException*: Returning autogenerated keys is > not > > > > supported. > > > > > > > > at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.executeQuery(* > > > > ReadCommandImpl.java:65*) > > > > > > > > at > org.apache.tuscany.samples.das.customer.CustomerClient.getCustomers(* > > > > CustomerClient.java:168*) > > > > > > > > at org.apache.tuscany.samples.das.customer.CustomerClient.main(* > > > > CustomerClient.java:131*) > > > > > > > > Caused by: *org.postgresql.util.PSQLException*: Returning > autogenerated > > > keys > > > > is not supported. > > > > > > > > at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(* > > > > AbstractJdbc3Connection.java:352*) > > > > > > > > at org.apache.tuscany.das.rdb.impl.ConnectionImpl.prepareStatement (* > > > > ConnectionImpl.java:97*) > > > > > > > > at org.apache.tuscany.das.rdb.impl.Statement.getPreparedStatement (* > > > > Statement.java:198*) > > > > > > > > at org.apache.tuscany.das.rdb.impl.Statement.executeQuery(* > > > Statement.java:52 > > > > *) > > > > > > > > at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.executeQuery(* > > > > ReadCommandImpl.java:61*) > > > > > > > > Regards, > > > > Enric > > > > > > > > 2007/7/5, Luciano Resende <[EMAIL PROTECTED]>: > > > > > > > > > > Yes, the typical one should work. I particularly haven't tried > with > > > > > PostgreSQL, but I don't anticipate any issues, you might have to > > > > > manually create the databases, or maybe tweak the database > generation > > > > > classes under o.a.t.samples.das.databaseSetup. > > > > > > > > > > Once you make it working, and if you want, you could share your > > > > > updates so we can make it easier for others that want to use the > > > > > sample with PostgreSQL. I'll be more then happy to review and > submit > > > > > it to trunk. > > > > > > > > > > On 7/5/07, Enric Staromiejski Torregrosa < > [EMAIL PROTECTED]> > > > > > wrote: > > > > > > by the way, the database engine i'll have to use is PostgreSQL > 8.1, > > > but > > > > > the > > > > > > configuration has to be a typicall one, isn't it, something > like: > > > > > > > > > > > > <ConnectionInfo> > > > > > > <ConnectionProperties > > > > > > driverClass="org.postgresql.Driver" > > > > > > > databaseURL="jdbc:postgresql:databasename" > > > > > > user="enric" > > > > > > password="mypassword" > > > > > > loginTimeout="600000"> > > > > > > </ConnectionProperties> > > > > > > </ConnectionInfo> > > > > > > > > > > > > > > > > > > 2007/7/5, Enric Staromiejski Torregrosa < > [EMAIL PROTECTED] > > > >: > > > > > > > > > > > > > > i imagined...but even if i get driverClass accepted, "Feature > > > user" is > > > > > > > not.... > > > > > > > > > > > > > > i'm really impressed and happy with your presence and > > > > > collaboration...it's > > > > > > > greatly encouraging to a newby ;) > > > > > > > > > > > > > > > > > > > > > Enric > > > > > > > > > > > > > > 2007/7/5, Luciano Resende <[EMAIL PROTECTED]>: > > > > > > > > > > > > > > > > The XSD is available here [1]. I would need to give it a try > > > using > > > > > > > > MySQL, but giving it a quick look on the DAS config files, > looks > > > > > like > > > > > > > > connection info other then the derby one hasn't been updated > > > > > recently, > > > > > > > > and you would need to make some small modifications to it. > > > > > > > > > > > > > > > > <ConnectionInfo> > > > > > > > > <ConnectionProperties > > > > > > > > driverClass=" > > > > > > > > com.mysql.jdbc.jdbc2.optional.MysqlDataSource" > > > > > > > > > databaseURL="java:comp/env/jdbc/dastest" > > > > > > > > user="root" > > > > > > > > password="yourpassword" > > > > > > > > loginTimeout="600000"> > > > > > > > > </ConnectionProperties> > > > > > > > > </ConnectionInfo> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [1] > > > > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/incubator/tuscany/java/das/rdb/src/main/resources/config.xsd > > > > > > > > > > > > > > > > On 7/5/07, Enric Staromiejski Torregrosa < > > > > > [EMAIL PROTECTED] > > > > > > > > > wrote: > > > > > > > > > Yeah, but the path seems hard, hard. > > > > > > > > > > > > > > > > > > I just discovered the problem is not related with the > code, > > > but > > > > > with > > > > > > > > the > > > > > > > > > fact that i was trying to use another connection distinct > to > > > the > > > > > derby > > > > > > > > one. > > > > > > > > > I'm working with the default Customer sample code Tuscany > is > > > > > > > > distributing. > > > > > > > > > When using the derby connection configuration everything > goes > > > > > well, > > > > > > > > but when > > > > > > > > > uncommenting the Mysql ConnectionInfo configuration and > > > commenting > > > > > the > > > > > > > > derby > > > > > > > > > one i'm still getting errors like the one i paste below. I > > > imagine > > > > > > > > people > > > > > > > > > are using other databases apart from derby, aren't they? > and > > > if > > > > > so, > > > > > > > > where's > > > > > > > > > the problem? btw, where can i get the xsd for this xml? > (the > > > url > > > > > in > > > > > > > > the > > > > > > > > > namespace returns a 'not found page'). > > > > > > > > > > > > > > > > > > Caused by: * > > > > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException*: > > > > > > > > > Feature 'contextAvailable' not found. ( http:///temp.xml , > 46, > > > 30) > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.handleErrors > (* > > > > > > > > XMLLoadImpl.java > > > > > > > > > :80*) > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(* > > > > > XMLLoadImpl.java:275*) > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad (* > > > > > > > > > XMLResourceImpl.java:666*) > > > > > > > > > > > > > > > > > > at > > > org.apache.tuscany.sdo.util.resource.SDOXMLResourceImpl.doLoad > > > > > (* > > > > > > > > > SDOXMLResourceImpl.java :465*) > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.load(* > > > > > > > > XMLResourceImpl.java > > > > > > > > > :634*) > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load(* > > > > > > > > XMLDocumentImpl.java > > > > > > > > > :239*) > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load(* > > > > > > > > XMLDocumentImpl.java > > > > > > > > > :217*) > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLHelperImpl.load(* > > > > > > > > XMLHelperImpl.java:78*) > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLHelperImpl.load (* > > > > > > > > XMLHelperImpl.java:72*) > > > > > > > > > > > > > > > > > > at org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig (* > > > > > > > > ConfigUtil.java:52 > > > > > > > > > *) > > > > > > > > > > > > > > > > > > > > > > > > > > > 2007/7/5, Luciano Resende < [EMAIL PROTECTED]>: > > > > > > > > > > > > > > > > > > > > Great news Enric > > > > > > > > > > > > > > > > > > > > Just FYI, I think this was fixed by TUSCANY-1401 [1] > > > > > > > > > > > > > > > > > > > > [1] https://issues.apache.org/jira/browse/TUSCANY-1401 > > > > > > > > > > > > > > > > > > > > On 7/5/07, Enric Staromiejski Torregrosa < > > > > > > > > [EMAIL PROTECTED]> > > > > > > > > > > wrote: > > > > > > > > > > > The problem i reported in the mail below does not > occur > > > any > > > > > more > > > > > > > > with > > > > > > > > > > the > > > > > > > > > > > new "tuscany-das-1.0-incubating-beta1" binary version. > > > > > > > > > > > > > > > > > > > > > > Thks to all. > > > > > > > > > > > Enric > > > > > > > > > > > > > > > > > > > > > > ---------- Forwarded message ---------- > > > > > > > > > > > From: Enric Staromiejski Torregrosa < > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > Date: 02-jul-2007 20:06 > > > > > > > > > > > Subject: Trying to get started > > > > > > > > > > > To: [email protected] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > > > > > > > > > i'm trying to load a sample configuration file (from > the > > > > > samples > > > > > > > > > > distributed > > > > > > > > > > > by tuscany) like this: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Config config = > > > > > > > > > > > ConfigUtil.*loadConfig*(t.getClass > > > > > > > > > > ().getClassLoader().getResourceAsStream(configFile)); > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > where t is an instance of the current class, but I'm > get > > > the > > > > > > > > following > > > > > > > > > > > error: > > > > > > > > > > > > > > > > > > > > > > Exception in thread "main" > > > > > > > > > > > *java.lang.RuntimeException*: * > > > > > > > > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException*: > > > > > > > > Feature > > > > > > > > > > > 'ConnectionInfo' not found. (http:///temp.xml, 22, 20) > > > > > > > > > > > > > > > > > > > > > > at > org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig( > > > > > > > > > > > *ConfigUtil.java:54*) > > > > > > > > > > > > > > > > > > > > > > at _test.CATest.main( > > > > > > > > > > > *CATest.java:48*) > > > > > > > > > > > > > > > > > > > > > > Caused by: > > > > > > > > > > > * > > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException*:Feature > > > > > > > > > > > 'ConnectionInfo' not found. ( http:///temp.xml, 22, > 20) > > > > > > > > > > > > > > > > > > > > > > at > org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.handleErrors > > > ( > > > > > > > > > > > *XMLLoadImpl.java:80*) > > > > > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load( > > > > > > > > > > > *XMLLoadImpl.java:274*) > > > > > > > > > > > > > > > > > > > > > > at > org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad ( > > > > > > > > > > > *XMLResourceImpl.java:666*) > > > > > > > > > > > > > > > > > > > > > > at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.load > ( > > > > > > > > > > > *XMLResourceImpl.java:634*) > > > > > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load( > > > > > > > > > > > *XMLDocumentImpl.java:238*) > > > > > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load( > > > > > > > > > > > *XMLDocumentImpl.java :216*) > > > > > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLHelperImpl.load( > > > > > > > > > > > *XMLHelperImpl.java:75*) > > > > > > > > > > > > > > > > > > > > > > at org.apache.tuscany.sdo.helper.XMLHelperImpl.load( > > > > > > > > > > > *XMLHelperImpl.java:69*) > > > > > > > > > > > > > > > > > > > > > > at > org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig( > > > > > > > > > > > *ConfigUtil.java:52*) > > > > > > > > > > > > > > > > > > > > > > ... 1 more > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > Luciano Resende > > > > > > > > > > Apache Tuscany Committer > > > > > > > > > > http://people.apache.org/~lresende > > > > > > > > > > http://lresende.blogspot.com/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > Luciano Resende > > > > > > > > Apache Tuscany Committer > > > > > > > > http://people.apache.org/~lresende > > > > > > > > http://lresende.blogspot.com/ > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > > > > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Luciano Resende > > > > > Apache Tuscany Committer > > > > > http://people.apache.org/~lresende > > > > > http://lresende.blogspot.com/ > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > -- > > > Luciano Resende > > > Apache Tuscany Committer > > > http://people.apache.org/~lresende > > > http://lresende.blogspot.com/ > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > -- > Luciano Resende > Apache Tuscany Committer > http://people.apache.org/~lresende > http://lresende.blogspot.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
