[tinysql] insert with to many columns ?!?!?
Fabian Ruhoff
fabian.ruhoff@run-e.de
Fri, 30 Apr 2004 11:45:43 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0012_01C42EA8.ABDCE360
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi.
=20
danke f=FCr den schnellen support.
=20
CREATE TABLE cars (name CHAR(25), id NUMERIC(10));=20
=20
works fine !!!
=20
so hier kommt dir n=E4chste frage:
=20
INSERT INTO Intvrs=20
(INTCODE, NAME, ONSYSTEM, STATID, RESIGNED, EMPLID, BRIEFING, INT_HOURS,
QUOTASTYPE, STATUS, USERID, CMP_HOURS, SIDE_ID, CALL_TYPE, SHOW_STATS,
NETWORK_NO, NODE_ADDR, SOCKET_NO, EMPHASIS)=20
VALUES( '1', 'TestUser', 'F', 'a', 'F', 'a', 0, 0, 'a', 0, 'a', 0, 'a', =
'a',
'T', 'a', 'a', 'a', 'a' );
=20
=85 wie man sieht: ne ganze menge spalten=85 ( inserts in tabellen mit 4 =
oder 5
spalten funktionieren ohne probleme. )
=20
Exception:
=20
Error while generating statement: =
java.lang.ArrayIndexOutOfBoundsException:
-1
java.lang.ArrayIndexOutOfBoundsException: -1
at
ORG.as220.tinySQL.tinySQLTableView.getColumnDefinition(tinySQLTableView.j=
ava
:201)
at
ORG.as220.tinySQL.sqlparser.InsertStatement.addColumn(InsertStatement.jav=
a:9
4)
at
ORG.as220.tinySQL.parser.TinySQLParser.Insert(TinySQLParser.java:802)
at
ORG.as220.tinySQL.parser.TinySQLParser.getStatement(TinySQLParser.java:94=
)
at ORG.as220.tinySQL.tinySQL.parse(tinySQL.java:123)
=20
Kann das wirklich an der Anzahl von Spalten liegen?=20
=20
Danke im voraus.
=20
Fabian.
=20
=20
=20
------=_NextPart_000_0012_01C42EA8.ABDCE360
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DDE link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>hi.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>danke f=FCr den schnellen =
support.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<pre><font size=3D2 face=3D"Courier New"><span lang=3DEN-GB =
style=3D'font-size:10.0pt'>CREATE TABLE cars (name CHAR(25), id =
NUMERIC(10)); <o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN-GB =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 face=3D"Courier New"><span lang=3DEN-GB =
style=3D'font-size:10.0pt'>works fine =
!!!<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN-GB =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><fon=
t
size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt'>so hier =
kommt dir n=E4chste frage:<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt'><o:p> </o:p></span></font></pre>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>INSERT INTO Intvrs =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>(INTCODE, NAME, ONSYSTEM, STATID, RESIGNED, =
EMPLID,
BRIEFING, INT_HOURS, QUOTASTYPE, STATUS, USERID, CMP_HOURS, SIDE_ID, =
CALL_TYPE,
SHOW_STATS, NETWORK_NO, NODE_ADDR, SOCKET_NO, EMPHASIS) =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>VALUES( '1', 'TestUser', 'F', 'a', 'F', 'a', =
0, 0,
'a', 0, 'a', 0, 'a', 'a', 'T', 'a', 'a', 'a', 'a' =
);<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>… wie man sieht: ne ganze menge spalten… =
( inserts
in tabellen mit 4 oder 5 spalten funktionieren ohne probleme. =
)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Exception:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Error while generating statement:
java.lang.ArrayIndexOutOfBoundsException: =
-1<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>java.lang.ArrayIndexOutOfBoundsException: =
-1<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at
ORG.as220.tinySQL.tinySQLTableView.getColumnDefinition(tinySQLTableView.j=
ava:201)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at
ORG.as220.tinySQL.sqlparser.InsertStatement.addColumn(InsertStatement.jav=
a:94)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at
ORG.as220.tinySQL.parser.TinySQLParser.Insert(TinySQLParser.java:802)<o:p=
></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at
ORG.as220.tinySQL.parser.TinySQLParser.getStatement(TinySQLParser.java:94=
)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
</span></font><font size=3D2 face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>at =
ORG.as220.tinySQL.tinySQL.parse(tinySQL.java:123)<o:p></o:p></span></font=
></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Kann das wirklich an der Anzahl von Spalten liegen? =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Danke im voraus.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Fabian.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_0012_01C42EA8.ABDCE360--