Re: inputValidator usage
I have not used this tag myself nor did I hear of anybody using it. I am not even sure it works. Sorry, you have to finf out yourself, it seems :-( If you have found out what it does, can you please tell us? Thanks. Thomas On Mon, 16 Oct 2006, Alvaro Coronel wrote: Hello everybody. Can anyone please provide a useful pointer or hint about the usage of the inputValidator tag? Advice not only about schema definition but also at code level would be appreciated. TIA ?lvaro Coronel. - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: inputValidator usage
Sorry, did not see that Greg already responded to this. Please disregard my last email. Thomas On Tue, 17 Oct 2006, Thomas Fischer wrote: I have not used this tag myself nor did I hear of anybody using it. I am not even sure it works. Sorry, you have to finf out yourself, it seems :-( If you have found out what it does, can you please tell us? Thanks. Thomas On Mon, 16 Oct 2006, Alvaro Coronel wrote: Hello everybody. Can anyone please provide a useful pointer or hint about the usage of the inputValidator tag? Advice not only about schema definition but also at code level would be appreciated. TIA ?lvaro Coronel. - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Problems to set up a subquery
Hm, writing SQL is one of the the things that Torque wants to avoid. One of the reasons for this is portability between databases. Though Torque is certainly not perfectly portable, it is much better than plain SQL. Another reason is that the compiler checks if the columns you use in your query is still in your database model (it will not find the relevant constants if a column is removed or renamed and the model is regenerated) (of cousre, the constants can also be used to build SQL to have the same effect, but this is quite a hassle). So in my eyes, one should think twice before using custom SQL. There are cases where it cannot be avoided (see below), but I would think twice before using it. Thomas On Tue, 17 Oct 2006, [EMAIL PROTECTED] wrote: Hello, One thing that I have found very useful in complex queries is to bypass the Criteria objects. All you have to do is to write the SQL query, execute it using BasePeer.executeQuery() to get a List of Records and then create a list of persistent objects using the populateObjects of the corresponding Peer class. In this case, you can use: String query = SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN (SELECT kundenadress_id FROM adressenreferenz); List kundenadresses = KundenadressePeer.populateObjects(BasePeer.executeQuery(query)); It works fine if you have a query of the form: select * from foo..., ie you select all the columns of a single table. I don't have the source code handy to check if this query would work (my feeling is that this would work also): String query = SELECT * FROM FOO f, BAR b WHERE f.b = b.f AND ...; List list = FooPeer.populateObjects(BasePeer.executeQuery(query)); Enjoy, Antonis Hi, Subqueries are implemented and documented in the svn version(3.2.1-dev), but not in Torque 3.2.0. Either build Torque from svn or, if you want to use Torque 3.2.0. you can code the subquery as custom criteria (see http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.html#Using_the_CUSTOM_modifier_to_use_custom_SQL) (you can also build the subquery via another Criteria and its toString()-method if you do not want to hand-code it). Thomas Pfiester, Jan [EMAIL PROTECTED] schrieb am 16.10.2006 17:40:05: Hi everyone, I ran into problems to setup the following query using criteria: SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN( SELECT kundenadress_id FROM adressenreferenz ); Could someone please give me some help to come up with a proper solution? Hints for further reading on this topic would also be very much appreciated! Many thanks in advance, Jan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Torque as avalon service and use of the DataSourceSelector service
Hi, I have to admit that I have never used avalon nor do I know the reasoning for separating the TorqueInstance class from the Torque class, so this may be of limited or no value to you. Internally, most (if not all)Torque classes use the Torque.java object to access their configuration. The Torque object has a reference to a TorqueInstance object which is _INTERNALLY_ used by the Torque.java object to access the configuration. So you cannot get around a static configuration of Torque in the current version, as far as I can see. I do not see a way to use TorqueInstance instead of the static Torque object. This has its reason that Torque is intended to be a standalone component, and the avalon part is just an addon. Of course you can provide your own implementation of TorqueInstance instance by using the Torque.setTorqueInstance method, and thus override the getDataSourceFactory() part. I cannot see anything against using an own factory, but then I'm no avalon user and do not see the evil in this :-) Hope this helps. If I have been writing nonsense, perhaps Thomas V can correct me, he is using avalon himself. Thomas F Stefano Bagnara [EMAIL PROTECTED] schrieb am 14.10.2006 19:21:03: Hi all, we integrated Torque in Apache James trunk for our IMAP storage needs. James is currently Avalon based and works on Avalon. I saw there is an Avalon component for James but I saw it does not depend on the DataSourceSelector component that we currently use to access the db. I thought we could write our own torque avalon service depending on datasourceselector but I'm not sure we can do this. I see Torque need a static configuration of the class used as the datasource factory while using DataSourceSelector the datasource is obtained via dependency injection or service lookup. Maybe we should switch from Torque static usage to TorqueInstance? Pardon my ignorance on Torque: Using TorqueInstance is it possible to override its getDataSource to ask the datasource to the DataSourceSelector? I see that generated om contains static Torque.method calls: how do this integrate with the TorqueInstance usage/configuration? Is this possible? Otherwise I think I have to use publish the datasource selector via JNDI and to use the JNDI factory or to put the datasourceselector in a static field and then access it via a custom factory but I don't like this solutions (static fields/singleton are bad in then avalon world) so I'm investigating other options first. Thank you for any suggestion! Stefano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: Problems to set up a subquery
Hi again, at first many thanks to both of you for your quick response! I hope that Antonis is not feeling offended but i agree with Thomas that the problem should be solved by means of the framework and not via SQL-statements written by hand. Unfortunately, although spending the entire morning on this one, i couldn't come up with a solution yet. Thomas, you mentioned that using custom critera would be a good idea. This is what i was thinking too, but I don't rely get how the custom subquery and the parent query can be combined? So what i did is that i followed the subquery-way like this: Criteria criteria = new Criteria(); Criteria subCriteria = new Criteria(); subCriteria.addSelectColumn(AdressenreferenzPeer.KUNDENADRESS_ID); System.out.println(subCriteria.toString()); results = AdressenreferenzPeer.doSelect(subCriteria); criteria.addNotIn(AdressenreferenzPeer.KUNDENADRESS_ID, results); criteria.add(KundenadressePeer.KUNDEN_ID, kundeId, Criteria.EQUAL); criteria.setDistinct(); System.out.println(criteria.toString()); results = KundenadressePeer.doSelect(criteria); return results; 1st:In general: The doSelect of subquery throws an exception i don't really understand. Isn't it the right way to specify the columns you want in your resultset? com.workingdogs.village.DataSetException: Only 1 columns exist! = subCriteria.addSelectColumn(AdressenreferenzPeer.KUNDENADRESS_ID); similar to: SELECT kundenadress_id FROM adressenreferenz ?? 2nd:I don't think that this solution does not do the job cause its actually two queries instead of on cascaded one... 3rd:Thomas could you please give an example how you'd combine query and subquery according to this example? I really appreciate your help! Many thanks in advance, Jan -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Oktober 2006 09:35 An: Apache Torque Users List Cc: Thomas Fischer Betreff: RE: Problems to set up a subquery Hm, writing SQL is one of the the things that Torque wants to avoid. One of the reasons for this is portability between databases. Though Torque is certainly not perfectly portable, it is much better than plain SQL. Another reason is that the compiler checks if the columns you use in your query is still in your database model (it will not find the relevant constants if a column is removed or renamed and the model is regenerated) (of cousre, the constants can also be used to build SQL to have the same effect, but this is quite a hassle). So in my eyes, one should think twice before using custom SQL. There are cases where it cannot be avoided (see below), but I would think twice before using it. Thomas On Tue, 17 Oct 2006, [EMAIL PROTECTED] wrote: Hello, One thing that I have found very useful in complex queries is to bypass the Criteria objects. All you have to do is to write the SQL query, execute it using BasePeer.executeQuery() to get a List of Records and then create a list of persistent objects using the populateObjects of the corresponding Peer class. In this case, you can use: String query = SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN (SELECT kundenadress_id FROM adressenreferenz); List kundenadresses = KundenadressePeer.populateObjects(BasePeer.executeQuery(query)); It works fine if you have a query of the form: select * from foo..., ie you select all the columns of a single table. I don't have the source code handy to check if this query would work (my feeling is that this would work also): String query = SELECT * FROM FOO f, BAR b WHERE f.b = b.f AND ...; List list = FooPeer.populateObjects(BasePeer.executeQuery(query)); Enjoy, Antonis Hi, Subqueries are implemented and documented in the svn version(3.2.1-dev), but not in Torque 3.2.0. Either build Torque from svn or, if you want to use Torque 3.2.0. you can code the subquery as custom criteria (see http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.html#Using_the_CUSTOM_modifier_to_use _custom_SQL) (you can also build the subquery via another Criteria and its toString()-method if you do not want to hand-code it). Thomas Pfiester, Jan [EMAIL PROTECTED] schrieb am 16.10.2006 17:40:05: Hi everyone, I ran into problems to setup the following query using criteria: SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN( SELECT kundenadress_id FROM adressenreferenz ); Could someone please give me some help to come up with a proper solution? Hints for further reading on this topic would also be very much appreciated! Many thanks in advance, Jan
AW: Problems to set up a subquery
OMG, i must have been sleeping... Problem solved... Many thanks again to both of you! This problem still remains unsolved: 1st:In general: The doSelect of subquery throws an exception i don't really understand. Isn't it the right way to specify the columns you want in your resultset? com.workingdogs.village.DataSetException: Only 1 columns exist! = subCriteria.addSelectColumn(AdressenreferenzPeer.KUNDENADRESS_ID); similar to: SELECT kundenadress_id FROM adressenreferenz ?? May be you guys could give a hint anyway Jan -Ursprüngliche Nachricht- Von: Pfiester, Jan [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Oktober 2006 13:20 An: Apache Torque Users List Betreff: AW: Problems to set up a subquery Hi again, at first many thanks to both of you for your quick response! I hope that Antonis is not feeling offended but i agree with Thomas that the problem should be solved by means of the framework and not via SQL-statements written by hand. Unfortunately, although spending the entire morning on this one, i couldn't come up with a solution yet. Thomas, you mentioned that using custom critera would be a good idea. This is what i was thinking too, but I don't rely get how the custom subquery and the parent query can be combined? So what i did is that i followed the subquery-way like this: Criteria criteria = new Criteria(); Criteria subCriteria = new Criteria(); subCriteria.addSelectColumn(AdressenreferenzPeer.KUNDENADRESS_ID); System.out.println(subCriteria.toString()); results = AdressenreferenzPeer.doSelect(subCriteria); criteria.addNotIn(AdressenreferenzPeer.KUNDENADRESS_ID, results); criteria.add(KundenadressePeer.KUNDEN_ID, kundeId, Criteria.EQUAL); criteria.setDistinct(); System.out.println(criteria.toString()); results = KundenadressePeer.doSelect(criteria); return results; 1st:In general: The doSelect of subquery throws an exception i don't really understand. Isn't it the right way to specify the columns you want in your resultset? com.workingdogs.village.DataSetException: Only 1 columns exist! = subCriteria.addSelectColumn(AdressenreferenzPeer.KUNDENADRESS_ID); similar to: SELECT kundenadress_id FROM adressenreferenz ?? 2nd:I don't think that this solution does not do the job cause its actually two queries instead of on cascaded one... 3rd:Thomas could you please give an example how you'd combine query and subquery according to this example? I really appreciate your help! Many thanks in advance, Jan -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Oktober 2006 09:35 An: Apache Torque Users List Cc: Thomas Fischer Betreff: RE: Problems to set up a subquery Hm, writing SQL is one of the the things that Torque wants to avoid. One of the reasons for this is portability between databases. Though Torque is certainly not perfectly portable, it is much better than plain SQL. Another reason is that the compiler checks if the columns you use in your query is still in your database model (it will not find the relevant constants if a column is removed or renamed and the model is regenerated) (of cousre, the constants can also be used to build SQL to have the same effect, but this is quite a hassle). So in my eyes, one should think twice before using custom SQL. There are cases where it cannot be avoided (see below), but I would think twice before using it. Thomas On Tue, 17 Oct 2006, [EMAIL PROTECTED] wrote: Hello, One thing that I have found very useful in complex queries is to bypass the Criteria objects. All you have to do is to write the SQL query, execute it using BasePeer.executeQuery() to get a List of Records and then create a list of persistent objects using the populateObjects of the corresponding Peer class. In this case, you can use: String query = SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN (SELECT kundenadress_id FROM adressenreferenz); List kundenadresses = KundenadressePeer.populateObjects(BasePeer.executeQuery(query)); It works fine if you have a query of the form: select * from foo..., ie you select all the columns of a single table. I don't have the source code handy to check if this query would work (my feeling is that this would work also): String query = SELECT * FROM FOO f, BAR b WHERE f.b = b.f AND ...; List list = FooPeer.populateObjects(BasePeer.executeQuery(query)); Enjoy, Antonis Hi, Subqueries are implemented and documented in the svn version(3.2.1-dev), but not in Torque 3.2.0. Either build Torque from svn or, if you want to use Torque 3.2.0. you can code the subquery as custom criteria
Need a sample Torque application
Hi, I am new to the torque. Can somebody send me any sample working Torque application? Because I am facing problems in the torque configuration. Thanks. regards, Anand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Torque plugin for Eclipse
Hi. Is there any plugin available for Torque in eclipse If yes, then kindly forward me the download URL. Thanks. regards, Anand \ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: Need a sample Torque application
Specify your needs and your problems please... -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Oktober 2006 13:45 An: Apache Torque Users List Betreff: Need a sample Torque application Hi, I am new to the torque. Can somebody send me any sample working Torque application? Because I am facing problems in the torque configuration. Thanks. regards, Anand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: Need a sample Torque application
Hi, I have configured them. There is no error in Maven. I am following the Torque tutorial provided by Apache torque website. According to the tutorial, we get database mapping classes created by the torque. Refer: http://db.apache.org/torque/releases/torque-3.2/tutorial/step3.html But its not creating expected classes in my case. Instead of that it is creating few Turbine classes inside src/java directory. Hence, I need a sample working Torque application. If you have it, kindly forward it to me. Thanks. regards, Anand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Problems to set up a subquery
I agree with you, but there are a few cases that there is no alternative: delete all records from a table ( FooPeer.doDelete(new Criteria()) will not work). We had to iterate over the list of all records and call delete for each one. complex queries with subqueries and/or multiple references to the same column. It can be done using Criteria, but some times I find it much easier to create the query by hand, especially if many parts of the query are optional. Antonis Thomas Fischer wrote: Hm, writing SQL is one of the the things that Torque wants to avoid. One of the reasons for this is portability between databases. Though Torque is certainly not perfectly portable, it is much better than plain SQL. Another reason is that the compiler checks if the columns you use in your query is still in your database model (it will not find the relevant constants if a column is removed or renamed and the model is regenerated) (of cousre, the constants can also be used to build SQL to have the same effect, but this is quite a hassle). So in my eyes, one should think twice before using custom SQL. There are cases where it cannot be avoided (see below), but I would think twice before using it. Thomas On Tue, 17 Oct 2006, [EMAIL PROTECTED] wrote: Hello, One thing that I have found very useful in complex queries is to bypass the Criteria objects. All you have to do is to write the SQL query, execute it using BasePeer.executeQuery() to get a List of Records and then create a list of persistent objects using the populateObjects of the corresponding Peer class. In this case, you can use: String query = SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id NOT IN (SELECT kundenadress_id FROM adressenreferenz); List kundenadresses = KundenadressePeer.populateObjects(BasePeer.executeQuery(query)); It works fine if you have a query of the form: select * from foo..., ie you select all the columns of a single table. I don't have the source code handy to check if this query would work (my feeling is that this would work also): String query = SELECT * FROM FOO f, BAR b WHERE f.b = b.f AND ...; List list = FooPeer.populateObjects(BasePeer.executeQuery(query)); Enjoy, Antonis ... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Torque plugin for Eclipse
There is not a specific Torque plug-in but since it's Maven and Ant driven, it works fine in this environment. There is a Maven plug-in for Eclipse that can run the generator, see www.mevenide.codehaus.org. FYI, Torque still works best with Maven 1.x, 2.x support is still rudimentary. FWIW, I use ant build files for my projects and these work well in Eclipse. For editing Schema files, there is a lot of Eclipse XML options out there. I use Eclipse with the MyEclipse addin and this does a decent job of handling XML validation, etc. One thing to remember is that Torque is not like a lot of other OM layers. It requires very little bookwork (unlike that H.. word one 8) ) and hence IMHO no specific plugin is needed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 8:05 AM To: Apache Torque Users List Subject: Torque plugin for Eclipse Hi. Is there any plugin available for Torque in eclipse If yes, then kindly forward me the download URL. Thanks. regards, Anand \ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: AW: Need a sample Torque application
Here's the basics for this step... Before running maven torque in project directory: project | project.properties | +---src +---java +---schema bookstore-schema.xml id-table-schema.xml After running maven torque project directory: project | project.properties | velocity.log | +---src | +---java | | | report.bookstore.om.generation | | | | | +---my | | | +---torque | | | +---om | | | | Author.java | | | | AuthorPeer.java | | | | BaseAuthor.java | | | | BaseAuthorPeer.java | | | | BaseBook.java | | | | BaseBookPeer.java | | | | BasePublisher.java | | | | BasePublisherPeer.java | | | | Book.java | | | | BookPeer.java | | | | Publisher.java | | | | PublisherPeer.java | | | | | | | +---map | | | AuthorMapBuilder.java | | | BookMapBuilder.java | | | BookstoreMapInit.java | | | PublisherMapBuilder.java | | | | | +---org | | +---apache | | +---torque | | +---linkage | | BookstoreMapInit.java | | | +---schema | bookstore-schema.xml | id-table-schema.xml | +---target +---sql bookstore-schema.sql id-table-schema.sql report.bookstore.sql.generation sqldb.map project.properties: == # The name of the project Torque will generate code for. torque.project = bookstore # The target database platform. torque.database = mssql # The target package to put the generated classes in. torque.targetPackage = my.torque.om # The JDBC URL that Torque can use to create and # drop databases if instructed to do so. torque.database.createUrl = jdbc:mysql://127.0.0.1/mysql # The JDBC URL that will be used to create tables in your database. torque.database.buildUrl = jdbc:mysql://127.0.0.1/bookstore # The JDBC URL that will be used to access your database. torque.database.url = jdbc:mysql://127.0.0.1/bookstore # The JDBC database driver to use when connecting to your database. torque.database.driver = org.gjt.mm.mysql.Driver # The administrative username that has sufficient privileges to create # and drop databases and tables that Torque executes at generation time. torque.database.user = adminuser # The administrative password for the supplied username. torque.database.password = adminpassword === Contents of bookstore-schema.xml === !DOCTYPE database SYSTEM http://db.apache.org/torque/dtd/database_3_2.dtd; database name=bookstore defaultIdMethod=idbroker table name=publisher description=Publisher Table column name=publisher_id required=true primaryKey=true type=INTEGER description=Publisher Id/ column name=name required=true type=VARCHAR size=128 description=Publisher Name/ /table table name=author description=Author Table column name=author_id required=true primaryKey=true type=INTEGER description=Author Id/ column name=first_name required=true type=VARCHAR size=128 description=First Name/ column name=last_name required=true type=VARCHAR size=128 description=Last Name/ /table table name=book description=Book Table column name=book_id required=true primaryKey=true type=INTEGER description=Book Id/ column name=title required=true type=VARCHAR size=255 description=Book Title/ column name=isbn required=true type=VARCHAR size=24 javaName=ISBN description=ISBN Number/ column name=publisher_id required=true type=INTEGER description=Foreign Key Publisher/ column name=author_id required=true type=INTEGER description=Foreign Key Author/ foreign-key foreignTable=publisher reference local=publisher_id foreign=publisher_id/ /foreign-key foreign-key foreignTable=author reference local=author_id foreign=author_id/ /foreign-key /table /database Contents of id-table-schema.xml !DOCTYPE database SYSTEM http://db.apache.org/torque/dtd/database_3_2.dtd; database name=bookstore table name=ID_TABLE idMethod=idbroker column name=ID_TABLE_ID required=true primaryKey=true type=INTEGER/ column name=TABLE_NAME
Re: Torque plugin for Eclipse
I can confirm that the ant scripts work fine in Eclipse. Don't forget the build.properties though - which eclipse does confuse with plugins but just click the plain text edit or use a different name in the ant build file. Remember to press F5 (refresh) after a generate too! :-) We use WTP 1.5 and it has good XML validation/editting. Joe On 17/10/06, Greg Monroe [EMAIL PROTECTED] wrote: There is not a specific Torque plug-in but since it's Maven and Ant driven, it works fine in this environment. There is a Maven plug-in for Eclipse that can run the generator, see www.mevenide.codehaus.org. FYI, Torque still works best with Maven 1.x, 2.x support is still rudimentary. FWIW, I use ant build files for my projects and these work well in Eclipse. For editing Schema files, there is a lot of Eclipse XML options out there. I use Eclipse with the MyEclipse addin and this does a decent job of handling XML validation, etc. One thing to remember is that Torque is not like a lot of other OM layers. It requires very little bookwork (unlike that H.. word one 8) ) and hence IMHO no specific plugin is needed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 8:05 AM To: Apache Torque Users List Subject: Torque plugin for Eclipse Hi. Is there any plugin available for Torque in eclipse If yes, then kindly forward me the download URL. Thanks. regards, Anand \ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
MSSQL Insert problem
I'm getting this error whenever I try to insert into
my identity table through my website.
Cannot insert explicit value for identity column in
table 'CONTACTS' when IDENTITY_INSERT is set to OFF.
Supposedly you add:
SET IDENTITY_INSERT table ON
...
SET IDENTITY_INSERT table OFF
around your generated Insert statement, but I'm not
sure where, I was thinking I should add to my row.vm
located in templates/sql/load/mssql but this doesn't
work. What is the exact syntax needed if this is
correct? My row.vm follows.
This generated sql wasn't created by me, although I
don't think it was through the datasql task.
I was thinking of running datasql, the Ant task, to
see what sql it generated, but I would need to run
datadump first and my database is too large.
--
row.vm
INSERT INTO $row.Table.Name (##
#set ($comma=)#foreach($col in
$row.ColumnValues)$comma${col.Column.Name}#set($comma=,)#end)
VALUES (#set ($comma=)#foreach($col in
$row.ColumnValues)$comma${generator.parse(sql/load/mssql/val.vm,
, column, $col)}#set ($comma=,)#end);
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
