Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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=60 /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
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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=60 /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
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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=60 /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
Re: New version solves Feature 'ConnectionInfo' not found problem
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: tuscany-user@ws.apache.org 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]
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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=60 /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: tuscany-user@ws.apache.org 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
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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: tuscany-user@ws.apache.org 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
Re: New version solves Feature 'ConnectionInfo' not found problem
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: tuscany-user@ws.apache.org 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]
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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: tuscany-user@ws.apache.org 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*)
Re: New version solves Feature 'ConnectionInfo' not found problem
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=60 /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=60 /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