Re: OJB 1.0.x and Java5.0

2005-08-07 Thread Jason Pyeron
Yes we use Java 5.0 in our Crisfield product, but we have not migrated our 
OJB projects to it yet.


On Sun, 7 Aug 2005, [ISO-8859-1] Tino Schöllhorn wrote:


Hi,

we are currently thinking of moving from JDK1.4.2 to Java 5.0.x. The most 
interesting part of new Java Editition is the use of Generics which will lead 
to a much better understandable code-base. I have a few questions, which 
might be answered by someone of the OJB community:


- Are there any known issues of using OJB 1.0.x with Java 5.0?
- If so, will OJB 1.1 work with Java 5.0?
- Does anyone use Java 5.0 in a production system?

Perhaps someone already has expierience with Java 5.0 and OJB and can share 
this information.


With regards
Tino


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218   -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Future of OJB?

2005-05-03 Thread Jason Pyeron

Could you please explain more.

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (410) 808-6646 (c) Baltimore, Maryland 21218   -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



mysql, ojb palm pilot?

2005-04-05 Thread Jason Pyeron


does any one know if, palm has the capability of running mysql or hsql with 
ojb?

examples?


-jason pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager  #1 2739 Saint Paul Street  -
- +1 (410) 808-6646 (c)  Baltimore, Maryland 21218  -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



database connections...

2004-09-22 Thread Jason Pyeron

PersistenceBroker broker;
//...
Connection C=broker.serviceConnectionManager().getConnection();

do we close this connection when we are done?

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager  #1 2739 Saint Paul Street  -
- +1 (410) 808-6646 (c)  Baltimore, Maryland 21218  -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: MySQL and primary keys

2004-08-26 Thread Jason Pyeron

Thanks it was the primary key was not auto_increment.

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



MySQL and primary keys

2004-08-26 Thread Jason Pyeron

Can anyone help with this one?

I feel very silly, it has been a long time since I used OJB.

Now I am trying to use odmg, just like section 4.4.3.3, but I get an 
exception.

org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while 
insert object data for class  
com.pyerotechnics.product.bozman.tier1.dataobjects.AutoBaseObject$members,  
PK of the given object is [ id=null], object was  
[EMAIL PROTECTED], 
exception message is 

[General error,  message from server: "Column 'id' cannot be null"]

the full trace and my repository.xml, OJB.properties are at

 http://projects.pyerotechnics.com/show_bug.cgi?id=140

Many thanks,

Jason Pyeron

p.s. out Reverse DB tool is coming along nicely

 http://public.pyerotechnics.com/cordova

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: reverse db app ideas, needs review

2004-08-24 Thread Jason Pyeron
Since some people have attachement blockers on their system, here is a 
link:

http://www.pyerotechnics.com/AutoBase.tgz


On Tue, 24 Aug 2004, Jason Pyeron wrote:

> 
> modify dump.bat for your needs.
> 
> will post web site soon
> 
> -jp
> 
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



reverse db app ideas, needs review

2004-08-24 Thread Jason Pyeron

modify dump.bat for your needs.

will post web site soon

-jp

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




AutoBase.tgz
Description: GNU Zip compressed data
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

out of the box SQL -> .java tool?

2004-08-20 Thread Jason Pyeron

Almost a year ago, we had started an in-house tool development like such, 
we figured since OJB has matured so much that there would be a mature tool 
to do such, preferably from ant.

http://db.apache.org/ojb/docu/howtos/howto-build-mappings.html
says that the ReverseDB tool is not up to date :(

Any links, ideas, etc.

Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.






-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: ojb-blank libs

2004-06-22 Thread Jason Pyeron
Look at how the FreeTTS project handles the "Legal/License" issues of the 
dist or jars.

they wrap the jars in an original license agreement, then the 
user/developer can accept or decline the agreements.


On Tue, 22 Jun 2004, Thomas Dudziak wrote:

> [EMAIL PROTECTED] wrote:
> 
> >  The ones that are missing, in order to execute the ojb-blank target are:
> >
> >  - jdo.jar
> >  - jdori.jar
> >  - j2ee.jar
> >  
> >
> Due to license issues, we're not allowed to bundle them with OJB, but 
> rather the user has to download them manually. Currently you need to add 
> the j2ee libraries (from Java J2EE SDK from http://java.sun.com) and jdo 
> libraries (also from http://java.sun.com, search for JDO RI) to the lib 
> subfolder in order to build OJB from source which is a prerequisite for 
> building the ojb-blank target.
> Btw, We will make a pre-compiled ojb-blank.jar available with the 1.0 
> (which does not need j2ee or jdo libraries).
> 
> Tom
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



OJB.properties/repository.xml in a jar file? Was Re: Problems using Tomcat + OJB

2003-12-03 Thread Jason Pyeron
We are trying to deploy an application as a single jar file. But we cant 
seem to get the OJB subsystem to load its files from inside the jar.

any suggestions?

Jason Pyeron


On Wed, 3 Dec 2003, Antonio Gallardo wrote:

> Rogerio Tambellini dijo:
> > Thanks for everyone, I just moved the files to WEB-INF/classes and worked.
> >
> > Unfortunatelly, in the OJB.properties, I had to write the fully static
> > directory to the repository file running at Tomcat.
> >
> > repositoryFile=../webapps/maritima/WEB-INF/classes/repository.xml
> 
> I just have:
> 
> repositoryFile=repository.xml
> 
> Also you need to deploy on the same dir:
> 
> OJB.properties and
> repository.dtd
> 
> That way I managed to have it working on Tomcat.
> 
> Best Regards,
> 
> Antonio Gallardo
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Object replication vs RDBMS replication (little off topic)

2003-11-30 Thread Jason Pyeron
ditto.

we have two (2) applications under way right now, which we want to do 
something similar.

1) n locations connected by a 90% up slow link, these locations need 
access to each others information, and not to conflict.

2) a port of bugzilla, which will allow offline entry/submission

-Jason Pyeron

On Sun, 30 Nov 2003, Colin Kilburn wrote:

> Gustavo,
> 
> I expect to have a project soon that will require some replication, although perhaps 
> with differing requirements, but I'm sure there'll be some overlap in requirements 
> as well as challenges.  At minimum I'd be interested in discussing issues and 
> approaches in this arena "soon" (I'm currently very tied up trying to finish another 
> project.)
> 
> What results from these efforts (or at least parts of them) may be generic enough to 
> be useful to others.  Anyone else?
> 
> Colin Kilburn
> 
> [EMAIL PROTECTED] wrote:
> 
> >Hi all,
> >
> >We’ve being using OJB for a while and we do like it. 
> >While we depart from the old paradigm (delegating the "important" stuff to 
> >the RDBMS) and we delegate OJB the real work, some 
> >opportunities/challenges come to our mind.
> >And since data/object replication is one of those opportunities, we would 
> >like to address in a new project. We believe OJB is ready for a job like 
> >this.
> >
> >Let’s say we have some data collection apps running in notebooks offsite. 
> >Thanks to OJB, the app runs on almost any RDBMS in every notebook (hsql, 
> >mysql, postgresql or any $$ vendor base rdbms) an in a main site storing 
> >the objects again in an opensource or $$vendor base dbms.
> >
> >Once the data collectors have a network connection available (either WAN 
> >or LAN) we would like them to "replicate" their objects with the main site 
> >or with other partners. Scheduled or ad-hoc replication, it just doesn´t 
> >matter. OJB would do it no matter when or where.
> >
> >The apps have some business objects that will remain with little or no 
> >changes through their life cycle (like the old master tables) ; some 
> >others will face heavy updates (customers service requests).
> >
> >If any of you are familiar with it, Lotus Notes/Domino type of replication 
> >is the best model of the replication mechanism we would like to implement 
> >in this project (but remember, at an object or better business object 
> >level replication, not record/document level replication).
> >
> >Let´s dream for a minute: OJB will let us replicate objects across 
> >different dbms, without even having the same schema (due to the 
> >repository.xml mapping magic)
> >
> >Among some other things, we will need to take care of things like unique 
> >ids across db replicas ( sequencers ), differential replication, 
> >replication conficts etc. 
> >
> >Any frameworks or ideas out there? Any volunteers to start an "OJB 
> >replicator" contribution to this great framework?
> >
> >Finally and again: Thanks Thomas and the whole OJB team!.
> >
> >Best regards,
> >
> >Gustavo Faerman
> >Buenos Aires, Argentina
> >  
> >
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



another tool for OJB...

2003-11-24 Thread Jason Pyeron

tested with MySQL and looking for others to review & suggest.

We have been getting pretty frustrated at having to setup OJB, rewrite the 
repository and java files every time an architecture change is made.


We sat down and tried to come up with a 'nice' way of doing it.

the factors considered were:
 versioning of the schema

 regeneration of the SQL schema / database initialization
 non-clobbering of code
 non-clobbering of manual repository.xml additions.

 obvious compile errors when schema changes result in OBJ object 
  definition changes

 portability


AutoBaseJDBCSchemaDumper:
 converts JDBC's DatabaseMetaData to XML
 it annotates some fields to make xsl stuff easier

AutoBaseInterface.xsl:
 this creates a java file which can be used for proxy, etc.

AutoBaseObject.xsl:
 this creates a java file which can be subclasses / instantiated

AutoBaseRepository.xsl:
 this creates a repository.xml fragment

AutoBaseSQL.xsl:
 this creates a SQL script of create tables, etc
 [ not done yet ]




http://www.pyerotechnics.com/products/AutoBase.tgz




-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: confused about how to port some sql queries...

2003-11-22 Thread Jason Pyeron
btw, this is what I am doing for now:
   PersistenceBroker broker=PersistenceBrokerFactory.defaultPersistenceBroker();
   Connection C=broker.serviceConnectionManager().getConnection();
   PreparedStatement stmt=C.prepareStatement("SELECT min(tsin) FROM timeclock WHERE 
ref_employee= ? AND tsout=0;");
   stmt.setInt(1,emp.getId());
   ResultSet rs=stmt.executeQuery();
   min=rs.getDate(1);
   rs.close();
   stmt.close();
   C.close();
   broker.close();


On Sat, 22 Nov 2003, Jason Pyeron wrote:

> 
> I have a prepared statement like so:
> 
> "SELECT min(tsin) FROM timeclock WHERE ref_employee= ? AND tsout=0;"
> 
> 
> I use this to decide what to query next, it sounds like I should use the 
> "report" feature in OJB but I have no idea how.
> 
> I looked at 
> 
> ReportQueryByCriteria(java.lang.Class targetClass, java.lang.String[] columns, 
> Criteria criteria) 
> 
> what is this targetClass?
> 
> Sincerely,
> 
> Jason Pyeron
> 
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



confused about how to port some sql queries...

2003-11-22 Thread Jason Pyeron

I have a prepared statement like so:

"SELECT min(tsin) FROM timeclock WHERE ref_employee= ? AND tsout=0;"


I use this to decide what to query next, it sounds like I should use the 
"report" feature in OJB but I have no idea how.

I looked at 

ReportQueryByCriteria(java.lang.Class targetClass, java.lang.String[] columns, 
Criteria criteria) 

what is this targetClass?

Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Which database to use - PostgreSQL or MySQL?

2003-11-17 Thread Jason Pyeron
MySQL is designed to be efficient at the sake of loss of ANSI 92 
comliance.

PostGreSQL is a great DATABASE but thats about it, poor admin, not that 
fast when it really matters.



On Mon, 17 Nov 2003, Robert J Celestino wrote:

> As far as ease of use with ojb, all are equal. 
> 
> So the following is just about preference, but take this with a grain of salt since 
> I am, by no means, a database "expert" (could that be why I am using OJB? :-) ).
> 
> I have used both postgresql and mysql on real production products. The impression I 
> get from most DB types, is that mysql is a "toy database" and postgress is more 
> "industrial strength". This may have been true 5 years ago, but I don't think that 
> is true anymore.  
> 
> I find that mysql has nicer tools. 
> 
> Given my experience I would vote for mysql. I find it up to any task I throw at it. 
> 
> 
> Bob Celestino
> SAS Research and Development
> 919 - 531 - 9425
> [EMAIL PROTECTED]
> 
> SAS - The Power to Know
> 
> 
>   > -Original Message-
>   > From: Jewett, Diane C [mailto:[EMAIL PROTECTED] 
>   > Sent: Monday, November 17, 2003 3:35 PM
>   > To: OJB Users List
>   > Subject: Which database to use - PostgreSQL or MySQL?
>   > 
>   > 
>   > What is the best and most reliable open-source database to use?
>   > 
>   > Is one easier to use with OJB?
>   > 
>   > 
>   > -
>   > 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]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Druid Working, More Info on How To

2003-11-17 Thread Jason Pyeron
BEAT DRUID WITH STICK or atleast with section 1.6 of the tutorial.

now on to code generation



-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Druid Working, More Info on How To

2003-11-17 Thread Jason Pyeron
yes that was line of thought too, until I wrote an DatabaseMetaData2XML 
util (posted earlier today) and all of the fk/pk/indecies were there.

On Mon, 17 Nov 2003, Charles Anthony wrote:

> 
> > From: Jason Pyeron [mailto:[EMAIL PROTECTED]
> > 
> > On Mon, 17 Nov 2003, Robert S. Sfeir wrote:
> > 
> > > I've figured out how to import existing tables if anyone is 
> > interested.
> > > 
> > > Setup your jdbc driver
> > ...
> > > Choose Import Entities
> > > 
> > > Check everything
> > 
> > where are the foreign keys
> [...]
> > 
> > I am an OJB user, I use MySQL4 and I have been doing things 
>   ^^
> Which version of the MySQL jdbc driver (JConnect ??) are you using ? 
> 
> According to http://www.mysql.com/downloads/api-jdbc-stable.html the latest
> release, 3.09 fixes some bugs to do with foreign key metadata on InnoDB
> tables.
> More info on one of the bugs here :
> http://bugs.mysql.com/bug.php?id=517 
> 
> I suspect that Druid uses the foreign key metadata stuff in the driver to do
> it's thang. If it ain't reported from MySql, Druid can't use it.
> 
> HTH,
> 
> Cheers,
> 
> Charles.
> 
> 
> ___
> HPD Software Ltd. - Helping Business Finance Business
> Email terms and conditions: www.hpdsoftware.com/disclaimer 
> 
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Druid Working, More Info on How To

2003-11-17 Thread Jason Pyeron
On Mon, 17 Nov 2003, Robert S. Sfeir wrote:

> I've figured out how to import existing tables if anyone is interested.
> 
> Setup your jdbc driver
...
> Choose Import Entities
> 
> Check everything

where are the foreign keys

> And just figured out how to generate the FULL schema using Druid... VERY
> VERY VERY SWEET!
> 
> To do that:
> 1- Click on the DB icon
...
> 7- Right click the Apache OJB icon and choose generate...
> 
> DONE!

where are my reference-descriptors, collections, etc


My OJB anonymous intro :)

I am an OJB user, I use MySQL4 and I have been doing things the hard way 
for 2 months.

-Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: [rc4 / BUG] major memory leak in MetadataManager

2003-11-17 Thread Jason Pyeron
On Mon, 17 Nov 2003, Charles Anthony wrote:

> However, if you do a mm.setDescriptor(null) after you've finished on the
> thread, presumably the space will be gc'd.

with out looking I would vote this solution to be a cure. It is logical at 
least.

jason


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [rc4 / BUG] major memory leak in MetadataManager

2003-11-17 Thread Jason Pyeron
On Mon, 17 Nov 2003, Janssen, Roger wrote:

> can anybody confirm this, is anybody working on this?

are you using ojb from CVS or download?

I will test it from CVS later on, hopefully today.

> for me this is a showstopper, which is kind of a problem because it occurs
> in a live hosted webapp.

if true, then DITO.

-Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: mysql [and others], code generation, repository generation...

2003-11-17 Thread Jason Pyeron
On Mon, 17 Nov 2003, Charles Anthony wrote:

> Give us a chance - it's early Monday morning over here in (Western) Europe !
> Alot of OJB developers are in Europe, and only deal with OJB mailing lists
> during the working week.

nothing to do with this weekend, but the last 2 months as a whole.

> 
> I notice you mentioned it in your previous subject header, have you tried it
> - and if so, what was the problem ?

no fk's extracted.

-Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



mysql [and others], code generation, repository generation...

2003-11-17 Thread Jason Pyeron

I have given up, now I am having a tool written.


Attached are some files to review. If you wan to please review them, make 
comments etc...

Sincerely,

Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.


/*



(c) 2003 Pyerotechnics Development, Inc.



*/

import java.sql.*;

import java.util.*;

import java.io.*;



public class DumpDatabase

{

 static HashMap s;

 static HashMap p;

 static HashMap o;

 static

 {

  s=new HashMap();

  o=new HashMap();

  p=new HashMap();

  s.put(new Integer(java.sql.Types.ARRAY),"ARRAY");

  s.put(new Integer(java.sql.Types.BIGINT),"BIGINT");

  s.put(new Integer(java.sql.Types.BINARY),"BINARY");

  s.put(new Integer(java.sql.Types.BIT),"BIT");

  s.put(new Integer(java.sql.Types.BLOB),"BLOB");

  s.put(new Integer(java.sql.Types.BOOLEAN),"BOOLEAN");

  s.put(new Integer(java.sql.Types.CHAR),"CHAR");

  s.put(new Integer(java.sql.Types.CLOB),"CLOB");

  s.put(new Integer(java.sql.Types.DATALINK),"DATALINK");

  s.put(new Integer(java.sql.Types.DATE),"DATE");

  s.put(new Integer(java.sql.Types.DECIMAL),"DECIMAL");

  s.put(new Integer(java.sql.Types.DISTINCT),"DISTINCT");

  s.put(new Integer(java.sql.Types.DOUBLE),"DOUBLE");

  s.put(new Integer(java.sql.Types.FLOAT),"FLOAT");

  s.put(new Integer(java.sql.Types.INTEGER),"INTEGER");

  s.put(new Integer(java.sql.Types.JAVA_OBJECT),"JAVA_OBJECT");

  s.put(new Integer(java.sql.Types.LONGVARBINARY),"LONGVARBINARY");

  s.put(new Integer(java.sql.Types.LONGVARCHAR),"LONGVARCHAR");

  s.put(new Integer(java.sql.Types.NULL),"NULL");

  s.put(new Integer(java.sql.Types.NUMERIC),"NUMERIC");

  s.put(new Integer(java.sql.Types.OTHER),"OTHER");

  s.put(new Integer(java.sql.Types.REAL),"REAL");

  s.put(new Integer(java.sql.Types.REF),"REF");

  s.put(new Integer(java.sql.Types.SMALLINT),"SMALLINT");

  s.put(new Integer(java.sql.Types.STRUCT),"STRUCT");

  s.put(new Integer(java.sql.Types.TIME),"TIME");

  s.put(new Integer(java.sql.Types.TIMESTAMP),"TIMESTAMP");

  s.put(new Integer(java.sql.Types.TINYINT),"TINYINT");

  s.put(new Integer(java.sql.Types.VARBINARY),"VARBINARY");

  s.put(new Integer(java.sql.Types.VARCHAR),"VARCHAR");

  p.put(new Integer(java.sql.Types.ARRAY),"Array");

  p.put(new Integer(java.sql.Types.BIGINT),"long");

  p.put(new Integer(java.sql.Types.BINARY),"byte[]");

  p.put(new Integer(java.sql.Types.BIT),"boolean");

  p.put(new Integer(java.sql.Types.BLOB),"Blob");

  p.put(new Integer(java.sql.Types.BOOLEAN),"boolean");

  p.put(new Integer(java.sql.Types.CHAR),"String");

  p.put(new Integer(java.sql.Types.CLOB),"Clob");

  p.put(new Integer(java.sql.Types.DATALINK),"?");

  p.put(new Integer(java.sql.Types.DATE),"java.sql.Date");

  p.put(new Integer(java.sql.Types.DECIMAL),"java.math.BigDecimal");

  p.put(new Integer(java.sql.Types.DISTINCT),"??");

  p.put(new Integer(java.sql.Types.DOUBLE),"double");

  p.put(new Integer(java.sql.Types.FLOAT),"double");

  p.put(new Integer(java.sql.Types.INTEGER),"int");

  p.put(new Integer(java.sql.Types.JAVA_OBJECT),"???");

  p.put(new Integer(java.sql.Types.LONGVARBINARY),"byte[]");

  p.put(new Integer(java.sql.Types.LONGVARCHAR),"String");

  p.put(new Integer(java.sql.Types.NULL),"");

  p.put(new Integer(java.sql.Types.NUMERIC),"java.math.BigDecimal");

  p.put(new Integer(java.sql.Types.OTHER),"?");

  p.put(new Integer(java.sql.Types.REAL),"float");

  p.put(new Integer(java.sql.Types.REF),"Ref");

  p.put(new Integer(java.sql.Types.SMALLINT),"short");

  p.put(new Integer(java.sql.Types.STRUCT),"Struct");

  p.put(new Integer(java.sql.Types.TIME),"java.sql.Time");

  p.put(new Integer(java.sql.Types.TIMESTAMP

RE: Archives... http://db.apache.org/mail.html

2003-11-16 Thread Jason Pyeron
I am just looking for a link, from db.apache.org which is easy to find, 
and always working. If I have to use google to do a 
+site:www.archive.dom/path then so beit.

Just a link, is that too much to ask for?

I would have no problem having our sysadmin setup such a site.

ps: Is there a tgz file for all the past posts somewhere?
maybe on someones hdd?



On Sun, 16 Nov 2003, Antonio Gallardo wrote:

> Hi:
> 
> It is true. The mailarchives in OJB are not the best for searching.
> Personally, I prefer MARC:
> 
> http://marc.theaimsgroup.com/
> 
> If the OJB PMC agree I think it is a nice place to start an mailarchive
> for all maillist of OJB. BTW, Apache Cocoon use MARC between others and
> people prefer it. See:
> 
> http://cocoon.apache.org/community/mail-archives.html
> 
> Best Regards,
> 
> Antonio Gallardo
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-       -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Archives... http://db.apache.org/mail.html

2003-11-16 Thread Jason Pyeron
no the point of my email was:

 1) fix the links if they are borken
 2) if the archives dont exist then ...


http://db.apache.org/ojb/mail-lists.html says there are no archives
http://db.apache.org/mail.html links are broken.
http://db.apache.org/ojb/mail-archives.html links are broken/sites unreliable


On Mon, 17 Nov 2003, Shane Mingins wrote:

http://archives.apache.org/eyebrowse/[EMAIL PROTECTED]
he.org

does not work, but have you tried

http://news.gmane.org/thread.php?group=gmane.comp.jakarta.ojb.user

and 

http://www.mail-archive.com/ojb-user%40db.apache.org/


both on 

http://db.apache.org/ojb/mail-archives.html

HTH
Shane


> -Original Message-
> From: Jason Pyeron [mailto:[EMAIL PROTECTED]
> Sent: Monday, 17 November 2003 10:50 a.m.
> To: OJB Users List; OJB Dev List
> Subject: Archives... http://db.apache.org/mail.html
> 
> 
> Can the archive link be fixed?
> if there are no archives currently, can the be created?
> 
> we will provide the resources if needed.
> 
> This is very frustrating.
> 
> Sincerely,
> 
> Jason Pyeron
> 
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> -       -
> - Jason Pyeron   http://www.pyerotechnics.com   -
> - Partner & Sr. Manager Pyerotechnics Development, Inc. -
> - +1 (443) 451-2697 500 West University Parkway #1S -
> - +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
> -   -
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you
> have received it in error, purge the message from your system and
> notify the sender immediately.  Any other use of the email by you
> is prohibited.
> 
> 
> 
> 
> -
> 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]


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Archives... http://db.apache.org/mail.html

2003-11-16 Thread Jason Pyeron

Can the archive link be fixed?
if there are no archives currently, can the be created?

we will provide the resources if needed.

This is very frustrating.

Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Druid, OJB, MySQL...

2003-11-16 Thread Jason Pyeron

OK I have been going out of my mind. I am still looking for a solution to 
generate the repository.xml, and some .java files for my MySQL (4.x 
InnoDB w/ FK's) schema.

Can anyone walk me through it (once), and I will then write up some docs 
on how to do it.

Sincerely,

Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.






-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: OJB Still alive? [yes]

2003-11-15 Thread Jason Pyeron
tes/StateOldClean.java
U src/java/org/apache/ojb/odmg/states/StateOldDelete.java
P src/java/org/apache/ojb/otm/copy/MetadataObjectCopyStrategy.java
P src/java/org/apache/ojb/otm/copy/ReflectiveObjectCopyStrategy.java
P src/java/org/apache/ojb/otm/core/ConcreteEditingContext.java
P src/java/org/apache/ojb/otm/transaction/LocalTransactionFactory.java
U src/schema/ojbtest-schema.xml
P src/test/org/apache/ojb/repository.dtd
U src/test/org/apache/ojb/repository.xml
P src/test/org/apache/ojb/repository_internal.xml
P src/test/org/apache/ojb/repository_junit.xml
U src/test/org/apache/ojb/repository_junit_cloneable.xml
P src/test/org/apache/ojb/broker/AllTests.java
P src/test/org/apache/ojb/broker/BatchModeTest.java
P src/test/org/apache/ojb/broker/LogServiceTest.java
P src/test/org/apache/ojb/broker/MetaDataSerializationTest.java
P src/test/org/apache/ojb/broker/NestedFieldsTest.java
P src/test/org/apache/ojb/broker/OJBPerfTest.java
P src/test/org/apache/ojb/broker/PersistenceBrokerTest.java
P src/test/org/apache/ojb/broker/QueryTest.java
P src/test/org/apache/ojb/broker/ReferenceTest.java
U src/test/org/apache/ojb/broker/cloneable/CloneableGroup.java
P src/test/org/apache/ojb/broker/sequence/NativeIdentifierTest.java
P src/test/org/apache/ojb/broker/sequence/SequenceManagerHandle.java
P src/test/org/apache/ojb/broker/sequence/SequenceManagerTest.java
P src/test/org/apache/ojb/broker/sqlcount/AbstractCountTest.java
U src/test/org/apache/ojb/broker/sqlcount/AllTests.java
P src/test/org/apache/ojb/broker/sqlcount/CollectionCountTest.java
U src/test/org/apache/ojb/broker/sqlcount/EmptyCacheCountTest.java
P src/test/org/apache/ojb/broker/sqlcount/SimpleCountTest.java
U src/test/org/apache/ojb/broker/sqlcount/TwoLevelSimpleTest.java
P src/test/org/apache/ojb/odmg/AllTests.java
P src/test/org/apache/ojb/odmg/ODMGRollbackTest.java
P src/test/org/apache/ojb/odmg/OQLTest.java
U src/test/org/apache/ojb/odmg/PersonWithArrayTest.java
P src/test/org/apache/ojb/otm/OtmExamples.java
P src/test/org/apache/ojb/p6spy/CountLogger.java
P src/test/org/apache/ojb/performance/PerfHandle.java
P src/test/org/apache/ojb/performance/PerfTest.java
P xdocs/lockmanager.xml
U xdocs/query.xml
P xdocs/repository.xml
U xdocs/tutorial3.xml

C:\tmp\db-ojb>


On Fri, 14 Nov 2003, Robert S. Sfeir wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Hi, I haven't been on here for a while, and still using OJB, but I
> noticed that the latest is still rc4, and it's been like that for a
> while, and wanted to know if it was still under development, of the
> authors have parked development and I should look into other solutions
> such as EJB etc...
> 
> Thanks for any response you can provide.
> 
> R
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.2.3 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQE/tODj+cV9vuB27SARAvy6AKCsmcnWAONXYA8OQFnq2Fs8HDgTYQCg9W/V
> ur8CHCkA7WdTeFo0inem8oY=
> =j7NB
> -END PGP SIGNATURE-
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
- +1 (443) 451-2697 500 West University Parkway #1S -
- +1 (410) 808-6646 (c) Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Invalid SQL call statements generated

2003-10-04 Thread Jason Pyeron
I have been trying to fix my MySQL identity column issues, I turned off 
Mysql's auto increment, now using the High Low sequencer

but I get preparedCall not supported, why is OJB trying to prepare calls?

should it not be prepare statement?

my jars are compiled from cvs tip

-Jason Pyeron

...



 
 
 


...

 
  
  
 

...

   AddressTypes at=new AddressTypes(); //AddressTypesCollection.java:38
   at.setName("Work"); //AddressTypesCollection.java:39
   broker.beginTransaction();  //AddressTypesCollection.java:40
   broker.store(at);   //AddressTypesCollection.java:41
   broker.commitTransaction(); //AddressTypesCollection.java:42

...


[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: Callable statments 
not supported. 
java.sql.SQLException: Callable statments not supported.
at com.mysql.jdbc.Connection.prepareCall(Connection.java:1201)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:1221)
at 
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:306)
at 
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getInsertStmt(StatementsForClassImpl.java:184)
at 
org.apache.ojb.broker.accesslayer.StatementManager.getInsertStatement(StatementManager.java:691)
at 
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:224)
at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:2026)
at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1943)
at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:661)
at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at 
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(SequenceManagerHighLowImpl.java:289)
at 
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(SequenceManagerHighLowImpl.java:191)
at 
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(AbstractSequenceManager.java:125)
at 
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.java:303)
at 
org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java:349)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:215)
at org.apache.ojb.broker.Identity.init(Identity.java:165)
at org.apache.ojb.broker.Identity.(Identity.java:129)
at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:651)
at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at 
com.pyerotechnics.customer.mmserv.rejistore.tier1.AddressTypesCollection.refresh(AddressTypesCollection.java:41)
at 
com.pyerotechnics.customer.mmserv.rejistore.tier1.AddressTypesCollection.(AddressTypesCollection.java:19)

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Invalid SQL call statements generated

2003-10-04 Thread Jason Pyeron
I noticed that too, I had chalked it up to my previous problem with mysql.

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



mysql identity columns?

2003-10-03 Thread Jason Pyeron
Any suggestions on this? I am trying to inser a NEW Address object.

-Jason Pyeron

class com.pyerotechnics.customer.mmserv.rejistore.tier1.dataobjects.Addresses:>
 addr1:t
 addr2:t
 addr3:t
 city:t
 id:null
 name:test
 notes:x
 postal:t
 state:t
 type:Work
 typeRef:null
 phoneNumbers:null

org.apache.ojb.broker.PersistenceBrokerException: assertValidPkFields failed for 
Object of type: 
com.pyerotechnics.customer.mmserv.rejistore.tier1.dataobjects.Addresses on insert
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
at 
com.pyerotechnics.customer.mmserv.rejistore.tier2.swing.controls.data.AddressEditor.store(AddressEditor.java:76)
at 
com.pyerotechnics.customer.mmserv.rejistore.tier2.swing.controls.data.AddressEditor$1.actionPerformed(AddressEditor.java:40)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)


  

  


...


 
  
  
  
   
  

  



-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



multiple JVM proxy example

2003-09-29 Thread Jason Pyeron
Does any one know of a simeple nocache proxy multiple JVM example?


Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



reverse-db issue:

2003-09-13 Thread Jason Pyeron
any one get this before?

this was after the read button was pushed.

[EMAIL PROTECTED] db-ojb-1.0.rc4]$ ant reverse-db
Buildfile: build.xml

reverse-db:
[reversedb] Using MySQL-AB JDBC Driver 3.0.8-stable ( $Date: 2003/05/19 00:57:19 $, 
$Revision: 1.27.2.18 $ )
[reversedb] java.lang.NullPointerException
[reversedb] at 
org.apache.ojb.tools.mapping.reversedb.DBSchema.read(DBSchema.java:126)
[reversedb] at 
org.apache.ojb.tools.mapping.reversedb.DBCatalog.read(DBCatalog.java:164)
[reversedb] at org.apache.ojb.tools.mapping.reversedb.DBMeta.read(DBMeta.java:224)
[reversedb] at 
org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.analyzeSchema(JFrmMainFrame.java:128)

Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.






-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: updating using SQL ansi & udfs

2003-09-01 Thread Jason Pyeron
On Mon, 1 Sep 2003, Roland Carlsson wrote:

> Why should you use sql when OJB handles the situation without any problem? 
> http://db.apache.org/ojb/tutorial1.html scroll down to "Updating Objects".
> 
> From: "Jason Pyeron" <[EMAIL PROTECTED]>
> Sent: Sunday, August 31, 2003 10:31 PM
> 
> >  UPDATE table_name SET date_col=NOW() WHERE id=###;
> > 
> > How should this be done under OJB?


my question was how can I use UDF's and other functions which the results 
are not able to be generated by the VM or any code running on it.


IE:


 obj.setName("bob smith");
 obj.setSpecialField(new SQLInline("MyUDF()"));


does anyone even know how to do this through update-able result-sets?

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



updating using SQL ansi & udfs

2003-08-31 Thread Jason Pyeron
To the list:

If I could do a SQL update of the like:

 UPDATE table_name SET date_col=NOW() WHERE id=###;

How should this be done under OJB?


Sincerely,

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: OJB.properties location issue...

2003-08-27 Thread Jason Pyeron
Thanks, 

it works like a charm.

# OJB.properties -- configuration of the OJB runtime environment
repositoryFile=data/conf/repository.xml

and then...

System.setProperty("OJB.properties","data/conf/OJB.properties");
new TestOJB().queryDatabase();


ps: how does one submit a (javadoc) patch for ORB?

Jason Pyeron


On Wed, 27 Aug 2003, Charles Anthony wrote:

> i.e. it seems you can specify the filename in the system property
> OJB.properties 
> 
> So
> 
> specify on the command line that start the JVM the following :
> -DOJB.properties=/fullpath/to/MyOJB.properties
> or
> -DOJB.properties=c:/temp/MyOJB.properties

or

-DOJB.properties=relative/path/to/MyOJB.properties

> 
> >-Original Message-
> >From: Jason Pyeron [mailto:[EMAIL PROTECTED]
> >Sent: Wednesday, August 27, 2003 5:15 PM
> >
> >Can the properties be spcified from the java code or better 
> >yet, can the 
> >location (and name?) of OJB.properties be specified?
> >

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



OJB.properties location issue...

2003-08-27 Thread Jason Pyeron
To all,

For silly reasons we are not allowed to put the OJB.properties file in a 
CLASSPATH directory.

Can the properties be spcified from the java code or better yet, can the 
location (and name?) of OJB.properties be specified?

TIA

Jason Pyeron


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron   http://www.pyerotechnics.com   -
- Partner & Sr. Manager Pyerotechnics Development, Inc. -
-   500 West University Parkway #1S -
- +1 (410) 808-6646 Baltimore, Maryland  21210-3253 -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]