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]
