Re: VARCHAR values are always the length of the field

2001-02-16 Thread Mikko Kurki-Suonio
On Wed, 14 Feb 2001, Edson Carlos Ericksson Richter wrote: But, how can I configure some Strings to VARCHAR(25) and others to VARCHAR(100) in the ejb-jar.xml??? Basically, you can't. BUT: You can hand-create the appropriate tables with the appropriate column types before deployment (or,

Re: VARCHAR values are always the length of the field

2001-02-16 Thread Edson Carlos Ericksson Richter
I think that all are crazy... I have one wizard in my company that create persistent classes that are so easy, not "deploy-then-copy-to-here-then-change-then-copy-to-there-then-deploy"!!! Why not Application Deployment Wizard does not ask for what datasource we want to use, what table name, and

RE: VARCHAR values are always the length of the field

2001-02-14 Thread Victor A. Salaman
I have some thoughts... don't be cheap and get rid of that piece of crap ODBC-JDBC bridge... buy a real jdbc driver. - peace - Victor! -Original Message- From: Michael S. Kelly [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 2:34 PM To: Orion-Interest Subject: VARCHAR

RE: VARCHAR values are always the length of the field

2001-02-14 Thread Michael S. Kelly
Hmmm...I've thought of that, but two other ways of accessing the same data (CMP and getting a connection from a DriverManager) work just fine with the ODBC-JDBC bridge. So, I've been operating on the assumption that the problem is elsewhere. -=michael=- -Original Message- From: [EMAIL

Re: VARCHAR values are always the length of the field

2001-02-14 Thread Edson Carlos Ericksson Richter
Try freetds jdbc driver... http://www.freetds.org But, how can I configure some Strings to VARCHAR(25) and others to VARCHAR(100) in the ejb-jar.xml??? I have found no response to this question... Edson Richter - Original Message - From: Victor A. Salaman [EMAIL PROTECTED] To:

RE: VARCHAR values are always the length of the field

2001-02-14 Thread Chandika Mendis
I don't have faith in the JDBC-ODBC bridge (it IS a piece of crap with lot's of bugs etc.). Yet, I was surprised to find that the JDBC-ODBC bridge was actually much faster than the Merant pure-java thin driver for SQL Server!! (very disappointing as I was expecting the performance to be better!)

RE: VARCHAR values are always the length of the field

2001-02-14 Thread Tim Endres
I do not think that JDBC is inherently the issue here. Think about it - if the JDBC-ODBC bridge is faster than the JDBC driver, how can that be? They are both based on JDBC, and the bridge has ODBC in the processing as well. Thus, I would conclude that the Merant JDBC driver is poorly written. In

Re: VARCHAR values are always the length of the field

2001-02-14 Thread Alex 'Kazuma' Garbagnati
But, how can I configure some Strings to VARCHAR(25) and others to VARCHAR(100) in the ejb-jar.xml??? I have found no response to this question... I'm afraid you can't. But, I think, that the best way, anyhow, is to build the table before... so you can design your table as "perfect" as you