Re: JDBC SQL problem

["Franco Biaggi" <fbiaggi@xxxxxxxxxx>]

sample code (running on a JBoss server as user service):

/**
         * Import articles, ignore any error
         */
        private void performImport(  ) {
                for ( ;; ) {
                        // Read the AS/400 file containing the updates
                        try {
                                //initialize connection
                                Class.forName( 
"com.ibm.as400.access.AS400JDBCDriver" );
                                Connection conn = DriverManager.getConnection( 
                                                "jdbc:as400://" + 
ActiveServer.getInstance(  ).getAS400SystemName(  ) + 
";transaction isolation=none; naming=system;libraries=" + getMyLibraries(),
                                                ActiveServer.getInstance(  
).getAS400UserId(  ), ActiveServer.getInstance(  
).getAS400UserPassword(  ) );
.......
........
............
                                // Release all the resources
                                conn.close(  );
                        } catch ( Throwable th3 ) {
                                // Ignore any error
                                System.out.println( "---Error in " + getClass(  
) + ": " + th3 );
                                th3.printStackTrace(  );
                        }

                        try {
                                Thread.sleep( ActiveServer.getInstance(  
).getAS400ArticlesImportDelay(  ) * 60L * 1000L ); // Sleep 
for nn minutes
                        } catch ( Throwable th4 ) {
                        }
                }
        }

On Tue, 02 Dec 2003 14:51:34 -0600, Glenn Holmer wrote:

>Franco Biaggi wrote:
>> Dieter,
>> I agree with you, but the AS/400 tables are stored in a library, not in a 
>> database (this is the system).
>> Using library lists allows you to access tables on multiple libraries, quick 
>> switch of test/prod environments etc.

>Can you change the library list using JDBC while the program is
>running?

>-- 
>____________________________________________________________
>Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
>Programmer/Analyst                       phone: 414.908.1809
>Weyco Group, Inc.                          fax: 414.908.1601

>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.



-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne