Hi!
The create table generated by JBoss is:
13:57:12,283 DEBUG [FBManagedConnection] preparing sql: CREATE TABLE
DC_USERS (username VARCHAR(30) NOT NULL, name VARCHAR(30), surname
VARCHAR(30), passwd VARCHAR(30), phone VARCHAR(30), address
VARCHAR(250), description VARCHAR(250), creation_date NUMERIC(18,0) NOT
NULL, CONSTRAINT PK_DC_USERS PRIMARY KEY (username))
The Numeric(18,0) is being converted to the previous datatype
(Description Iin this case). With description->VARCHAR(250), I get
creation_data->VARCHAR(250). I changed description to VARCHAR(150) and I
got creation_date VARCHAR(150).
Thanks again,
Victor Batista
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of David
Jencks
Sent: ter�a-feira, 1 de Outubro de 2002 13:14
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Firebird - Long mapping error
This is certainly not what I expect. What is the create table sql
generated by jboss?
david jencks
On 2002.10.01 07:22:29 -0400 Victor Batista wrote:
> Hi!
> I have changed the database dialect from 1 to 3!
> Now I correctly create the tables, although, my longs are
> converter to VARCHAR(250) - When I consult the database with the
> Marathon client.
>
> My long mapping is:
>
> <mapping>
> <java-type>java.lang.Long</java-type>
> <jdbc-type>BIGINT</jdbc-type>
> <sql-type>NUMERIC(18,0)</sql-type>
> </mapping>
>
> Is this the expected behaviour?
>
> Thanks again,
> Victor Batista
>
> -----Original Message-----
> From: David Jencks [mailto:[EMAIL PROTECTED]]
> Sent: sexta-feira, 27 de Setembro de 2002 21:12
> To: Victor Batista
> Subject: Re: [JBoss-user] Firebird - Long mapping error
>
> I don't remember if you can change the dialect of an existing db.
Using
> the FirebirdManager mbean you can create a new dialect 3 db. You can
> also
> do this with isql, but I don't remember the syntax. Ask on the
firebird
> lists or look at the docs.
>
> david jencks
>
> On 2002.09.27 06:11:39 -0400 Victor Batista wrote:
> > Hello!
> > Thanks for your reply!
> > I am a newbie with Firebird. How can I change the dialect from
> > "1! To "3".
> > Thanks and regards,
> > Victor Batista
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]] On Behalf Of David
> > Jencks
> > Sent: quinta-feira, 26 de Setembro de 2002 16:51
> > To: [EMAIL PROTECTED]
> > Subject: Re: [JBoss-user] Firebird - Long mapping error
> >
> > The best way is to use a dialect 3 database and the supplied
mapping.
> > Double precision is a really unsatisfactory way to represent a large
> > integer, I suggest if you need to use a dialect 1 db you not use
Long.
> >
> > david jencks
> >
> > On 2002.09.26 11:07:14 -0400 Victor Batista wrote:
> > > Hello!
> > > I am using tomcat 3.0.0 with bundled tomcat 4.0.3. I
am
> > > using the database Firebird (Firebird-1.0.0.796) with the driver
> > > FirebirdSQL-1.0_RC1. I am using the InterBase mapping
> > which
> > > is defined "standardjbosscmp-jdbc.xml" file. I am having problems
> > > when I use "long" fields within my CMP entity beans.
> > > According to "standardjbosscmp-jdbc.xml", the long mapping is:
> > > <mapping>
> > > <java-type>java.lang.Long</java-type>
> > > <jdbc-type>BIGINT</jdbc-type>
> > > <sql-type>NUMERIC(18,0)</sql-type>
> > > </mapping>
> > >
> > > The exception is:
> > > org.jboss.deployment.DeploymentException: Error while
> > > creating table; - nested throwable:
> > > (org.firebirdsql.jdbc.FBSQLException: GDS Exception:
> > > org.firebirdsql.gds.GDSException:
> > > Dynamic SQL ErrorSQL error code = -817
> > > Metadata update statement is not allowed by the
current
> > > database SQL dialect 1 null ....
> > >
> > > I have changed "NUMERIC(18,0)" by "DOUBLE PRECISION".
I
> > have
> > > done this, because I tried to create one table from the
> > > "Marathon" client with one column "NUMERIC(18,0" and
on
> > the
> > > DB I had the type "Double Precision" for that column.
> > >
> > > My new mapping:
> > > <mapping>
> > > <java-type>java.lang.Long</java-type>
> > > <jdbc-type>BIGINT</jdbc-type>
> > > <sql-type>DOUBLE PRECISION</sql-type>
> > > </mapping>
> > >
> > >
> > > Can anyone tell me which is the best way to map Longs
> with
> > > Firebird?
> > >
> > >
> > > Thanks in advance,
> > > Victor Batista
> > >
> > > <html xmlns:o="urn:schemas-microsoft-com:office:office"
> > > xmlns:w="urn:schemas-microsoft-com:office:word"
> > > xmlns="http://www.w3.org/TR/REC-html40";>
> > >
> > > <head>
> > > <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> charset=us-ascii">
> > >
> > >
> > > <meta name=ProgId content=Word.Document>
> > > <meta name=Generator content="Microsoft Word 10">
> > > <meta name=Originator content="Microsoft Word 10">
> > > <link rel=File-List href="cid:[EMAIL PROTECTED]";>
> > > <!--[if gte mso 9]><xml>
> > > <o:OfficeDocumentSettings>
> > > <o:DoNotRelyOnCSS/>
> > > </o:OfficeDocumentSettings>
> > > </xml><![endif]--><!--[if gte mso 9]><xml>
> > > <w:WordDocument>
> > > <w:SpellingState>Clean</w:SpellingState>
> > > <w:GrammarState>Clean</w:GrammarState>
> > > <w:DocumentKind>DocumentEmail</w:DocumentKind>
> > > <w:EnvelopeVis/>
> > > <w:Compatibility>
> > > <w:BreakWrappedTables/>
> > > <w:SnapToGridInCell/>
> > > <w:WrapTextWithPunct/>
> > > <w:UseAsianBreakRules/>
> > > </w:Compatibility>
> > > <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
> > > </w:WordDocument>
> > > </xml><![endif]-->
> > > <style>
> > > <!--
> > > /* Style Definitions */
> > > p.MsoNormal, li.MsoNormal, div.MsoNormal
> > > {mso-style-parent:"";
> > > margin:0in;
> > > margin-bottom:.0001pt;
> > > mso-pagination:widow-orphan;
> > > font-size:12.0pt;
> > > font-family:"Times New Roman";
> > > mso-fareast-font-family:"Times New Roman";
> > > mso-ansi-language:PT;}
> > > a:link, span.MsoHyperlink
> > > {color:blue;
> > > text-decoration:underline;
> > > text-underline:single;}
> > > a:visited, span.MsoHyperlinkFollowed
> > > {color:purple;
> > > text-decoration:underline;
> > > text-underline:single;}
> > > span.EmailStyle17
> > > {mso-style-type:personal-compose;
> > > mso-style-noshow:yes;
> > > mso-ansi-font-size:10.0pt;
> > > mso-bidi-font-size:10.0pt;
> > > font-family:Arial;
> > > mso-ascii-font-family:Arial;
> > > mso-hansi-font-family:Arial;
> > > mso-bidi-font-family:Arial;
> > > color:windowtext;}
> > > span.SpellE
> > > {mso-style-name:"";
> > > mso-spl-e:yes;}
> > > @page Section1
> > > {size:8.5in 11.0in;
> > > margin:1.0in 1.25in 1.0in 1.25in;
> > > mso-header-margin:.5in;
> > > mso-footer-margin:.5in;
> > > mso-paper-source:0;}
> > > div.Section1
> > > {page:Section1;}
> > > -->
> > > </style>
> > > <!--[if gte mso 10]>
> > > <style>
> > > /* Style Definitions */
> > > table.MsoNormalTable
> > > {mso-style-name:"Table Normal";
> > > mso-tstyle-rowband-size:0;
> > > mso-tstyle-colband-size:0;
> > > mso-style-noshow:yes;
> > > mso-style-parent:"";
> > > mso-padding-alt:0in 5.4pt 0in 5.4pt;
> > > mso-para-margin:0in;
> > > mso-para-margin-bottom:.0001pt;
> > > mso-pagination:widow-orphan;
> > > font-size:10.0pt;
> > > font-family:"Times New Roman";}
> > > </style>
> > > <![endif]-->
> > > </head>
> > >
> > > <body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
> > >
> > > <div class=Section1>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'>Hello!<o:p></o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>I
> > > am using tomcat 3.0.0 with bundled tomcat 4.0.3. I am using the
> > database
> > > Firebird (Firebird-1.0.0.796) with the
> > > driver<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>FirebirdSQL-1.0_RC1.
> > > I am using the InterBase mapping which is defined
> > > "standardjbosscmp-jdbc.xml" file. I am having problems
> > > <o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>when
> > > I use "long" fields within my CMP entity beans.
According
> to
> > > "standardjbosscmp-jdbc.xml", the long mapping
> > > is:<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'> </span><mapping><o:p></o:p></span><
> > /font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > > style='mso-spacerun:yes'>
> > >
> >
>
</span><java-type>java.lang.Long</java-type><o:p></o:p></spa
> > n></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'>  
> > ;
> > >
> >
>
</span><jdbc-type>BIGINT</jdbc-type><o:p></o:p></span></font
> > ></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > > style='mso-spacerun:yes'>
> > >
> >
>
</span><sql-type>NUMERIC(18,0)</sql-type><o:p></o:p></span><
> > /font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'>  
> > ;
> > > </span></mapping><o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>The
> > > exception is:<span
> >
>
style='mso-tab-count:1'>
> >
> > > </span><o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>org.jboss.deployment.DeploymentException:
> > > Error while creating table; - nested throwable:
> > > <o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>(org.firebirdsql.jdbc.FBSQLException:
> > > GDS Exception: org.firebirdsql.gds.GDSException:
> > > <o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>Dynamic
> > > SQL ErrorSQL error code = -817<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>Metadata
> > > update statement is not allowed by the current database SQL
dialect
> 1
> > > null ....<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>I
> > > have changed "NUMERIC(18,0)" by "DOUBLE
> > PRECISION". I
> > > have
> > > done this, because I tried to create one table from
> > > the<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>"Marathon"
> > > client with one column "NUMERIC(18,0" and on the DB I
had
> > the
> > > type
> > > "Double Precision" for that
> > > column.<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>My
> > > new mapping:<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'> </span><mapping><o:p></o:p></span><
> > /font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > > style='mso-spacerun:yes'>
> > >
> >
>
</span><java-type>java.lang.Long</java-type><o:p></o:p></spa
> > n></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > > style='mso-spacerun:yes'>
> > >
> >
>
</span><jdbc-type>BIGINT</jdbc-type><o:p></o:p></span></font
> > ></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'>  
> > ;
> > > </span><sql-type>DOUBLE
> > > PRECISION</sql-type><o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > >
> >
>
style='mso-spacerun:yes'> </span></mapping><o:p></o:p></span>
> > </font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span><o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span>Can
> > > anyone tell me which is the best way to map Longs with
> > > Firebird?<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > >
> >
>
font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></fon
> > t></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span
> > style='font-size:10.0pt;
> > > font-family:Arial;mso-ansi-language:EN-US'><span
> > >
> >
>
style='mso-tab-count:1'>
> >
> > > </span></span></font><span
> > > class=SpellE><font size=2 face=Arial><span lang=PT
> > > style='font-size:10.0pt;
> > > font-family:Arial'>Thanks</span></font></span><font size=2
> > > face=Arial><span
> > > lang=PT style='font-size:10.0pt;font-family:Arial'> <span
> > > class=SpellE>in</span>
> > > <span class=SpellE>advance</span>,<o:p></o:p></span></font></p>
> > >
> > > <p class=MsoNormal><font size=2 face=Arial><span lang=PT
> > > style='font-size:10.0pt;
> > > font-family:Arial'><span
> >
>
style='mso-tab-count:2'>
> >
>
> >
> > > </span><span
> > > class=SpellE>Victor</span> <span
> > class=SpellE>Batista</span><o:p></o:p></span></font></p>
> > >
> > > </div>
> > >
> > > </body>
> > >
> > > </html>
> > >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: DEDICATED SERVERS only $89!
> Linux or FreeBSD, FREE setup, FAST network. Get your own server
> today at http://www.ServePath.com/indexfm.htm
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
-------------------------------------------------------
This sf.net email is sponsored by: DEDICATED SERVERS only $89!
Linux or FreeBSD, FREE setup, FAST network. Get your own server
today at http://www.ServePath.com/indexfm.htm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This sf.net email is sponsored by: DEDICATED SERVERS only $89!
Linux or FreeBSD, FREE setup, FAST network. Get your own server
today at http://www.ServePath.com/indexfm.htm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
