Thread: Re: [Squirrel-sql-users] Installing squirrel-sql-2.4 Exception Error
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Tyrone B. <tyr...@ho...> - 2007-03-12 21:17:31
|
Install completed this morning. I'm trying to get to set it up to use the database. Now, I have this error but I think it is self explanatory. Really, I don't need the new version of this driver to work with the database. Right? JRE/JDBC Version Mismatch The Driver being used for alias 'rbadb' is not JDBC 3.0 compliant. You should consider getting a more recent version of this driver. >From: "Robert Manning" <rob...@gm...> >To: "Tyrone Baseck" <tyr...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] Installing squirrel-sql-2.4 Exception >Error >Date: Sun, 11 Mar 2007 20:27:47 -0500 > >On 3/11/07, Tyrone Baseck <tyr...@ho...> wrote: >>java version "1.3.1_04" >>Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_04-b02) >>Java HotSpot(TM) Client VM (build 1.3.1_04-b02, mixed mode) > >You need to use a JVM that is at least 1.5 to run the installer and >the 2.4.x series of SQuirreL. > >Rob _________________________________________________________________ Rates near 39yr lows! $430K Loan for $1,399/mo - Paying Too Much? Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18226&moid=7581 |
From: Robert M. <rob...@gm...> - 2007-03-12 23:03:46
|
On 3/12/07, Tyrone Baseck <tyr...@ho...> wrote: > Install completed this morning. I'm trying to get to set it up to use the > database. Now, I have this error but I think it is self explanatory. > Really, I don't need the new version of this driver to work with the > database. Right? > > JRE/JDBC Version Mismatch > The Driver being used for alias 'rbadb' is not JDBC 3.0 compliant. You > should consider getting a more recent version of this driver. That is correct. You can disable this message by unchecking: File -> Global Preferences -> General -> Warning for JRE/JDBC Version Mismatch Unfortunately, it's not that unusual for a current JDBC driver implementation to fail this check. This doesn't mean that the driver will present issues when used in SQuirreL. It simply means that the driver doesn't implement the same specification of JDBC that the JRE supports. Rob |
From: Tyrone B. <tyr...@ho...> - 2007-03-16 18:46:18
|
SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR) INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID WHERE (((PERS.PERS_ID)=3321)) ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm); I'm new. Why am I receiving the following error? Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "[Assignment Date]" was found following "ROLE_HIST.ASGN_TS AS". Expected tokens may include: "<space>". SQLSTATE=42601 , SQL State: 42601, Error Code: -104 _________________________________________________________________ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ |
From: Robert M. <rob...@gm...> - 2007-03-17 13:50:19
|
On 3/16/07, Tyrone Baseck <tyr...@ho...> wrote: > SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+" > ,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, > PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, > PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID > FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR) > INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON > ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID > WHERE (((PERS.PERS_ID)=3321)) > ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm); > > I'm new. Why am I receiving the following error? > > Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N > An unexpected token "[Assignment Date]" was found following > "ROLE_HIST.ASGN_TS AS". Expected tokens may include: "<space>". > SQLSTATE=42601 > , SQL State: 42601, Error Code: -104 Try quoting column aliases with quotes ("") instead of brackets ([]) Rob |
From: Tyrone B. <tyr...@ho...> - 2007-03-20 15:28:23
|
I will get help from the DBA on that query listed earlier. The one listed below works. Now, what is it doing: select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID where a.auth_req_id Do I need to change the MGD_REQ_HOLDG in the first line to look at another table? What is the lower case "m" and "a" for? Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it without the "a"? Sorry... This is SQL for dummies questions. >From: "Robert Manning" <rob...@gm...> >To: "Tyrone Baseck" <tyr...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] SQL 101 >Date: Sat, 17 Mar 2007 09:50:17 -0400 > >On 3/16/07, Tyrone Baseck <tyr...@ho...> wrote: >>SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+" >>,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, >>PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, >>PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, >>PERS.PERS_ID >>FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR) >>INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON >>ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID >>WHERE (((PERS.PERS_ID)=3321)) >>ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm); >> >>I'm new. Why am I receiving the following error? >> >>Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N >>An unexpected token "[Assignment Date]" was found following >>"ROLE_HIST.ASGN_TS AS". Expected tokens may include: "<space>". >>SQLSTATE=42601 >>, SQL State: 42601, Error Code: -104 > >Try quoting column aliases with quotes ("") instead of brackets ([]) > >Rob _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07 |
From: Robert M. <rob...@gm...> - 2007-03-20 21:40:44
|
On 3/20/07, Tyrone Baseck <tyr...@ho...> wrote: > I will get help from the DBA on that query listed earlier. The one listed > below works. Now, what is it doing: > > select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on > m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID > where a.auth_req_id > > Do I need to change the MGD_REQ_HOLDG in the first line to look at another > table? You are saying join tables MGD_REQ_HOLDG and AUTH_REQ_ITEM_HDR by matching records where the field REQ_ITEM_HDR_ID in both tables is equal. If you need columns from other tables, then you would add them to your join. The where clause : where a.auth_req_id is incomplete. You should give a value for auth_req_id like : where a.auth_req_id = 42 or not include a where clause at all (which could be quite a large number, depending on the data) > > What is the lower case "m" and "a" for? Table aliases are more convenient than using the entire table name. > > Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it > without the "a"? Both tables apparently have a column called REQ_ITEM_HDR_ID, so the database doesn't know which one you are referring to. The table aliases "m" and "a" tell it which one you mean. Rob |
From: Tyrone B. <tyr...@ho...> - 2007-03-21 02:01:34
|
>From: "Robert Manning" <rob...@gm...> >To: "Tyrone Baseck" <tyr...@ho...> >CC: squ...@li... >Subject: Re: [Squirrel-sql-users] SQL 101 >Date: Tue, 20 Mar 2007 17:40:42 -0400 > >On 3/20/07, Tyrone Baseck <tyr...@ho...> wrote: >>I will get help from the DBA on that query listed earlier. The one listed >>below works. Now, what is it doing: >> >>select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on >>m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID >>where a.auth_req_id >> >>Do I need to change the MGD_REQ_HOLDG in the first line to look at another >>table? > >You are saying join tables MGD_REQ_HOLDG and AUTH_REQ_ITEM_HDR by >matching records where the field REQ_ITEM_HDR_ID in both tables is >equal. If you need columns from other tables, then you would add them >to your join. The where clause : > >where a.auth_req_id > >is incomplete. You should give a value for auth_req_id like : > >where a.auth_req_id = 42 > >or not include a where clause at all (which could be quite a large >number, depending on the data) > >> >>What is the lower case "m" and "a" for? > >Table aliases are more convenient than using the entire table name. > >> >>Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it >>without the "a"? > >Both tables apparently have a column called REQ_ITEM_HDR_ID, so the >database doesn't know which one you are referring to. The table >aliases "m" and "a" tell it which one you mean. > > >Rob Oh!! So the a.REQ_ITEM_HDR_ID can be inputted as the following: AUTH_REQ_ITEM_HDR.REQ_ITEM_HDR_ID No answer needed on that comment. _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07 |