Parse .sql file
[166 byte] By [wilsonetoa] at [2007-11-27 5:37:39] 
Hello I wish to parse a .sql file and execute the queries in it, I have looked up for some solution but could not find one. Any Clue?ThanksWilson
# 1
Use Java.io to read the file in a buffer and split the queries on it's delimiter -which is usually the semicolon- and you're there.BalusCa at 2007-7-12 15:10:02 >
# 2
Any good to you? http://ant.apache.org/manual/CoreTasks/sql.htmldcmintera at 2007-7-12 15:10:02 >
Database Connectivity Hot Topic
- number of rows returned by SELECT LAST(column)
- PreparedStatement
- I have name of a savepoint, can i rollback to that savepoint?
- JDBC INSERT PROGRAM
- COUNT field incorrect or syntax error
- Problem with recycling connection pool
- Checking the existence of temp tables?
- max db
- Problem with HQL UPDATE
- Loading Driver
- How to retrieve nVarchat data from Sql Server DB
- Problem with retrieve ResultSet.getBytes("columnName");
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding