Nitin Agarwal

Hi,

I am using Hypersonic Database with java swing.
To update Hypersonic database, i am getting SQL Server script file through a webservice. Hypersonic has its own .script file of different format.
The problem is i dont have any idea, how i can update Hypersonic Database with the SQL Server script file.
Please Help.

Thanks
Nitin

Hi Michael Dunn ,


Thanks u Very much. My problem is solved now. But could u please tell me is this .chm will also run on Macintosh or there is any other format. Actually this application i am developing for Macintosh on Windows 2003 Server.

Nitin

Hi,

1. OS is Win 2003 Server and JVM version is 1.4.
2.When i put file name in cmd then it opens that help file.
3.Yes i tried full path of file but still it is giving same error.

Please try to solve it.

Thanks
Nitin

Hi,

I want to open Help file .chm on click of JButton. I am using following code on button click
but it is giving
error: CreateProcess: keywording.chm error=193


Runtime run = Runtime.getRuntime();
try
{
Process child = Runtime.getRuntime().exec("keywording.chm");
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println(ex.getMessage());
}



please tell me solution or any other easy way to do it.

Thanks,
Nitin

Hi,

how to convert binary data into jpg image through java.
I have xml file which contain <Binary> element in which binary data of image is fill and through java swing we have to read it and display image in JFrame.

Thanks
Nitin

Hi derby,

I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.

Also please help me with this problem too - I am passing a string value to a query. If I pass the string value "Teamwork" i get the desired result. But when i pass "teamwork" i get no value in return.
Is there any way to make the query run ignoring the case of the string value i pass?


Thanks
Nitin

Hi derby,

I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.

Thanks
Nitin

Hi Max,

That was most satisfying and best reply i have got from a forum.

Actually I m developing a desktop application in java swing on window 2003 server, i want to use lightweight database that can also run on Mac OS. Actually this application will be used on Mac OS. I find that SQLite DB is very light and fast.If u know any other database that is light,fast and easy to establish a connection with java so please suggest me.

Thanks for your cooperation

Nitin

Hi,

I m trying to establish connectivity between java and SQLite.

This is the code :

import java.sql.*; public class get{ public static void main(String[] args) { String url = "jdbc:sqlite:/E:/SQL Lite DB/keywording/keywording.db"; Connection con; String query = "select * from THESAURUS_SYNONYM"; Statement stmt; try { Class.forName("SQLite.JDBCDriver"); } catch(Exception e) { e.printStackTrace(); } } }


I have set Classpath for sqlite.jar file like :
java -cp E:\SQL Lite DB\sqlite.jar

It is giving error:
java.lang.ClassNotFoundException: SQLite.JDBC2y.JDBCConnection

I have opend jar file and see that this jar file contain package name JDBC2x and classes.
I have changed name of package to JDBC2y and make jar file and then use it but it is not working.

Please tell how can i get suitable jar file for this program. Tell me whole process for establishing connection between java and SQLite. Tell me some useful links for codes that establish connection between java and SQLite.

Please reply me in detail.

Thanks & Regards
Nitin

[edited to add line breaks]
[ December 15, 2005: Message edited by: Jeanne Boyarsky ]