Results 1 to 1 of 1
- 03-05-2009, 06:45 PM #1Member
- Join Date
- Feb 2009
- Rep Power
How do I insert local AUDIO data into a remote SQL Server 200x DB?
I have a local JAVA application connected to a remote DB using a sqlserver driver.
The table has strings, numbers and a varbinary column defined to hold audio data.
I used local *.SQL files in order to populate the tables initially. I used an OPENROWSET SINGLE_BLOB SQL call to move the audio data into the varbinary field, all that worked fine.
I've got the local JAVA code working to get the audio data OUT from the DB, am able to play it and i can also create new local audio data, in WAV file format.
What i don't have is the local SQL code to move the data back into the DB.
I don't have stored procedures written yet either for the DB so I am using hard-coded SQL statements and supplying the strings & numbers for the other fields but am a little stuck with how to deal with the audio data.
All the tutorials and books [we don't have that many] I have seen [so far] just use simple data type examples, like characters and numbers.
Any examples or thoughts would be greatly appreciated ?
- By sandeepsai39 in forum New To JavaReplies: 3Last Post: 02-28-2009, 10:17 AM
- By Masuka in forum Sun Java Wireless ToolkitReplies: 0Last Post: 08-05-2008, 08:43 PM
- By JavaJenius in forum NetworkingReplies: 1Last Post: 03-08-2008, 07:40 PM
- By mrcheeks in forum AWT / SwingReplies: 0Last Post: 01-22-2008, 12:05 PM
- By levent in forum Java SoftwareReplies: 0Last Post: 07-31-2007, 07:50 PM