• Subject: Re: Problem using SQL where library contains a period
  • From: "Richard Dettinger" <cujo@xxxxxxxxxx>
  • Date: Fri, 12 Jan 2001 09:32:22 -0600
  • Importance: Normal

You need to put quotes around the library name.  It works (at least
basically) just like iSQL.

iSQL Create example:
     create collection TRK1.5B
     Numeric constant .5B not valid.
     create collection "TRK1.5B"
     Collection "TRK1.5B" created.

Here is what you query line should be:

            ResultSet rs = s.executeQuery("SELECT * FROM

With the quotes around the name to signify that this is the collection, you
program will work (does for me anyway).

Good question though.


Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"

Lee Bircham <lee.bircham@socl.com>@midrange.com on 01/12/2001 06:26:57 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com

To:   "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
Subject:  Problem using SQL where library contains a period


I have a problem when using JDBC and SQL to access my AS400 database. The
problem happens when there is a period in the library name. Eg Library

An extract of my java code is as follows:
// Register Native JDBC Driver and connect to local DB.
Connection c = DriverManager.getConnection("jdbc:db2:*local");
// Run an SQL query on the table.
Statement s = c.createStatement();
ResultSet rs = s.executeQuery("SELECT * FROM TRK1.5B.T2USERP ORDER BY

When this is run I get the following error message:
java.sql.SQLException: Numeric constant .5B not valid.?

This is because there is a period in the library name and SQL doesn't like
If I change the library name to another that has no period eg TRKTEST the
java program works fine.
Any ideas apart from changing the library name on getting round this?


This E-Mail and any attachments maybe confidential and be the subject of
legal professional privilege.
Any disclosure , use, storage or copying of this E-Mail without the consent
of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended recipient
and then delete the E-Mail from
your inbox and do not disclose the contents to another person ,use, copy or
store the information in any medium.

| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.