SQL 2 « SQL « Java Database Q&A





1. SQL Coomand, LIMIT is not accepted    forums.netbeans.org

Whithout LIMIT all do work. What have I missed? NB-supplied MySQL driver is in use. It seems NB inserts somewhere own 'LIMIT 20 OFFSET 0' to devide result set into pages. ...

2. Netbeans 6.9 and java.sql    forums.netbeans.org

Posted: Wed Jul 14, 2010 5:28 am Post subject: Netbeans 6.9 and java.sql Hello. Recently, I upgraded to Netbeans 6.9 from NB 6.7.1. I am developing a database ...

3. Mimer SQL    forums.netbeans.org

Hi I'm looking for a SQL database product to use with Midlets developed for MIDP/CLDC environment. I have come across the MIMER SQL product http://developer.mimer.com/index.htm, which claims to work with JavaME. ...

4. NetBeans 6.9 and SQL 2005    forums.netbeans.org

I'm trying to connect to and read only a M$SQL 2005 DB. I have the latest and greatest M$SQL 2005 driver jar. When I create a Web App using NB 6.9, ...

5. netbeans 6.9 SQL command under Ubuntu 10.10    forums.netbeans.org

My main OS is Ubuntu 10.10 under which I run Windows XP in a Virtual box. I run Netbeans both under Ubuntu and XP. There is a problem with the Ubuntu version. If I click Servers and connect to mySQL I can see my database in both cases. I can open up the Tables and see all tables in both cases. ...

6. Editing SQL template    forums.netbeans.org

7. Netbeans 6.9.1 and SQL Anywhere 12.0.1    forums.netbeans.org

8. Netbeans 6.9.1 and SQL Anywhere 12.0.1    forums.netbeans.org

9. SQL Memory Leak?    forums.netbeans.org

Hi, Had the same issue before the patch upgrade, it was not present in the earlier releases of 6, just 6.5+. I could not track down what was really causing the memory leak, I did get rid of it though. In the process of attempting to track down I observed that it was very bad with Java 1.6 update > 7, ...





10. Monitoring triggers & jobs via SQL against QRTZ_    forums.terracotta.org

I recently found a trigger that got stuck and stopped executing. I noticed there was a row in QRTZ_FIRED_TRIGGERS that stayed in EXECUTING. And, in the QRTZ_SIMPLE_TRIGGERS table, the TIMES_TRIGGERED never incremented at the designated interval. That said... I'm interested in a few SQL calls I can execute in Oracle to see if a bot cron and simple triggers are deadlocked ...

11. Dynamically sending an SQL request in a "while controller"    jmeter.512774.n5.nabble.com

Hello, I have defined a loop for creating users. I would like to setup another loop for deleting these users; or delete the user I have just created. The problem is that the deletion of a user is based on the primary key set by the database at creation time; meaning that I can only loop on the primary key for ...

12. extracting output from sql output    jmeter.512774.n5.nabble.com

New bee for Jmeter as well as regex expression. I understand that I can use regex to extract the value of sqloutput from jdbc request output. But I don't know what should be the syntax of the regex expression I should use Output I see is like this SCHEDULEID 153 I want to extract value return by sql ( in this ...

13. Help on SQL datapopulation    jmeter.512774.n5.nabble.com

Hi friends, Can any one give me basic guidelines on SQL operations in jmeter.As of now i'm comfortable with web request and all. And now in need to enter into SQL transaction and database connectivity operations.A simple need here: Need to create 100 user into the database field.. Any suggestions? links? Thanks in advance --

14. How to run SQL log against database?    jmeter.512774.n5.nabble.com

Trying to test a file with saved SQL commands (one command per line) against a database. Have been connecting the file using CSV Data Set Config item. Trying to access the Data Set using a JDBC Request supported by a JDBC Connection. Is this the best way to feed SQL statements to a database to performance test the ...

15. SQL and javascript replace    jmeter.512774.n5.nabble.com

Hello, I'm having trouble doing a simple text substitution. I am currently pulling query type and query data for use in a JDBC Sampler out of a CSV file. I wanted to do some simple text substitution on the query strings before execution, and the __javaScript function seemed to be the answer. The query string I am using is: ${__javaScript('${query_value}'.replace('randomText'\,'testing 123'))} ...

16. SQL call returns header as the first line    jmeter.512774.n5.nabble.com

> Hello Jose, > > You probably get the result back as something as: > > COUNT > 236 > > You could process this result with a BeanShell Post processor. > > > Met Vriendelijke Groet, > Ronald van de Kuil > > Stuck in the past somewhere in the future? NO WAY!!! > > > > sebb <[hidden email]> ...





17. Timeout Problems for HTTP, SOAPXML and SQL requests    jmeter.512774.n5.nabble.com

We are using jmeter 2.3.1 for application testing. For testing HTTP Request we need to set a timeout, for example 20 sec In the file jmeter.properties we found # set the socket timeout (or use the parameter http.socket.timeout) #httpclient.timeout=0 # 0 == no timeout We have set httpclient.timeout=2 or to 10 but we got no timeout ...

18. RESTful web services and SQL    coderanch.com

You could, if you really want to, just pass the SQL query in as a GET parameter. You could also invent some mapping from SQL to a more traditional URL layout, but I would not recommend that either. There are several rasons for this. One reason is that it's nice to be able to change the SQL and/or the underlying database ...

19. Problem with Encoding SQL    coderanch.com

Hi Everyone This is a problem related to Encoding. I am uploading a particular unicode file in SQL server database in BLOB datatype. And later on I am retrieving that file and sending it as XML to the client bean. BUt when I parse the XML and regenerate the file at the client end, somehow the file is corrupted and is ...

20. Hashtable - SQL Like operation    coderanch.com

Krish, I agree with Stefan - 5000 isn't that many. Try it out and see how the performance is. If it turns out to be a bottleneck, you can split it into sublists by first character or something similar. One suggestion: wrap the HashMap in your own data structure. This will make changing the implementation much easier if you need it ...

21. sql Ecxeption in Entity Bean Help!!!    coderanch.com

22. memo field in SQL    coderanch.com

Hi, I am facing problems with the Memo field of MS Access in my database that i used for my online shopping. If I have even one memo field in my table, the SQL engine in the Netscape enterprise webserver (running on novell netware) would give "Invalid descriptor" error whenever i query the table thru my servlet program and thereby the ...

24. sql helper class    coderanch.com

I've got a class that only contains static methods in the form protected static ResultSet get...(Statement stmt, ... ) { return stmt.executeQuery( "Select ... "); } that all the servelts use to execute SQL statements. I use a connection pool that is thread safe to get DB connections but do these methods need to be synchronized also. The rule I've always ...

25. javax.sql - JBuilder6    coderanch.com

26. SQL and Javascript    coderanch.com

firstly I have 2 problems... I want to catch an empty SQL statement to deliver an error message to the user - currently the last SQL statement posted by the user is returned... Is there an isEmpty() method or similar? I have looked an found nothing on sun's website.. or if anyone has any ideas I would be greatful. ( : ...

27. I would like to extends java.sql.* package.    coderanch.com

Hello Friends, I would like to extend java.sql.* package by adding more features that will fetch/add/delete/modify dbase values in XML format directly. I mean to say instead of using/involving DOM/SAX/JAXP etc kind of stuff along with java.sql package. Add classes/interfaces/methods to the present SQL pacakage which will provide these functionality directly , if not all atleast the basics procedures. This will ...

28. SQL getFloat question    coderanch.com

More about this: I thought that I was getting confused between the SQL float type and the Java primitive float type. The ResultSet#getFloat() methods return a float, the Java primitive type, so that has only 6-7 sig fig. The SQL float type appears to be arbitrary precision, so you might be better seeing if you can get it into a BigDecimal. ...

31. java.sql. question    coderanch.com

32. Java & SQL    coderanch.com

Hello! Your String "SELECT Param1, Param2 FROM Tabel" will be send to the Database "as is", because the names Param1 etc. will not be replaced by their values. A simple solution might be to use this expression as parameter in your executeQuery-call "SELECT " + Param1 + ", " + Param2 + " FROM "+Tabel The values of the varaibles will ...

33. SQL    coderanch.com

34. using java.sql in my own class    coderanch.com

I'm writing a JSP page for a course and originally I had a bunch of code in my .jsp files, however, I'm trying to clean it up a bit by making use of Java classes. I made a package for my classes and wrote some functions in one of my classes. Originally, in the .jsp page i was doing: "include java.sql.*" ...

35. how write code to escape sql comments    coderanch.com

Oops, my bad on StringEscapeUtils. I went by the topic title, not by the example. I've done just what Srikanth suggested when reading SQL statements from a file. Read past the comments, read and concatenate lines until you find a semicolon. while (( line = readline ) != null ) if line starts with -- ignore it else statement = statement ...

36. Save information in SQL database using timer    coderanch.com

Hi everyone, I need help about using a timer in my application. I want a timer that starts when I push button1 (knop1) and saves information each 60 seconds in sql database. My idea is to insert this timer to my Knop1Handler. I tried this but its not working. I never worked with timers. And ideas how to insert this timer ...

37. SQL Reporting Services with Java EE    coderanch.com

I have developed a Java application for calling the SQL Reports. A couple of reports are made in the server. This SQL Reporting server is deployed and the client is made in the java using Werb services. Whenever a search is done from the Java application, reports are displayed on the JSP page using the web service methods. But the problem ...

38. SQL Reporting using Java    coderanch.com

39. Is this a Java Memory problem or a Windows / SQL Issue    coderanch.com

I have a server running a java application as a windows service using the open source wrapper.exe I connected to the server today and tried to run the desktop "swing" element of my application (on the server console) and encountered a error message which said something along the lines of "insufficient memory to execute query" The server has 4GB of RAM ...

40. gsl.sql.driv    coderanch.com

Rob Prime wrote:True. Moving to Java in General. As for the class, I haven't been able to find it. Where did you get that piece of code from? actually i want to access database table in jTable. im not able to do this in netbeans by drag n drop so i downloaded some example code im pasting that code ...

41. Dynamic or Static SQL is better?    dbforums.com

42. calling sql dts from java    dbforums.com

I'm trying to call a sql dts from java and for some reason I'm getting the syntax wrong. Currently I can call a stored procedure, but I can't seem to find the call for the DTS. Any clue? String serverURL = "jdbc:microsoft:sqlserver://amok:1433"; Class t = Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver"); Connection conn = DriverManager.getConnection (serverURL, user, password); CallableStatement procedure = conn.prepareCall( "{ call oraclePush ...

43. Migrating SQL to JDeveloper    dbforums.com

Hi everyone. I have a rather complex Oracle-based SQL query, with a Union in it and many subqueries and conversions for output and readability, and so it's rather huge, so I won't even post it here. It includes 4 tables all inner joined together (although a 5th one (actually a view) is used in several subqueries), and it has 6 variables ...

44. Database Metadata from SQL dump    dbforums.com

45. Tracing SQL in Java ?    dbforums.com

46. retry sql after a dealock ....    dbforums.com

I am having a problem finding a way to retry a sql after a deadlock (or any other error for that matter).... my current approach has been to put a 'try' block in a while loop and setting a variable in the 'catch' to detect the error... it does not seem to work... I am looking for a sample code to ...

47. Interactive SQL works/JDBC not working [alias/order by]    dbforums.com

I am having trouble with SQL that works using interactive or Perl/PHP interfaces, but fails using JDBC. This seems isolated to queries with ORDER BY in them. If I use an alias for a column name or a LEFT JOIN with ORDER BY I get an error; I have tried both the following drivers, org.gjt.mm.mysql.Driver and com.mysql.jdbc.Driver. General error, message from ...

48. add record in SQL    dbforums.com

hi all, i hope to get some help from u guys. i want to add record to DB but it doesn't work, the record cant be added to db. i've a java clas like below: public class CustomerDataBean { private Connection connection; private PreparedStatement addRecord, getRecords; private PreparedStatement sqlFind; // construct CustomerDataBean object public CustomerDataBean() throws Exception { // load the ...

49. some sql and netbeans help    java-forums.org

hello i am having some trouble running queries in netbeans for the following questions and was looking for a bit of help Care Managers must be able to find out: 1. The addresses of services that are available, 2. The unit cost of all night sitting services, 3. The number of their clients currently receiving services in each client group, 4. ...

50. Web service + sql    java-forums.org

hello :) l want to ceate a web service with connection for a data base . my web service containt 1 request for update . i use oracle 10g and netbeans 6.9 what are the servers and platforms (Tomcat, Axis ....) which I must add to netbeans for a web service works with Oracle 10g??

51. Button text to specific SQL reference    java-forums.org

Hi, I've got a java UI application in NetBeans that has multiple buttons, I've got the text on the buttons to display from an SQL database but the order is all messed up. Is there a way of referring the text on the button to a specific location within the SQL table, in layman's terms, jButton1 text = SQL table name ...

52. SQL and Netbeans tutorial    java-forums.org

I just figured out that netbeans can use a sql database built through netbeans. However I don't know the syntax to incorporate my program with a database. Does anyone know of a good tutorial for creating and implementing a database into a program through netbeans? I have looked on netbeans and it is very limited in the explanation given.

53. Quick and easy question about SQL databases.    java-forums.org

Hi, I am building an application which gets alot of information from files. Since I have never used SQL in a java enviroment I decided to use hashMaps, however as I have got further into the projects this has got very messy. Basically, all I want is a .sql which the program does queries on and stores the returned result into ...

54. migration of Ms-sql procedure to My-sql Procedure    java-forums.org

Hi, I am doing a project where i need to convert a MS sql Procedure to my sql Procedure. I have fetched the Procedure from Msql server database and tokenised it and stored the token in seperate text file. now i am trying to convert it in its respective MySQL code. but I am stuck with the logic for replacing if ...

55. java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword    java-forums.org

if (column == 1) { preparedStatement = connection.prepareStatement("update rms_accountstore customer_name = ? where customer_name like ?"); preparedStatement.setString(1, data.toString()); preparedStatement.setString(2, resultset.getObject(column + 1).toString()); [COLOR="red"]preparedStatement.executeUpdate();[/COLOR] } else if (column == 2) { preparedStatement = connection.prepareStatement("update rms_accountstore customer_address = ? where customer_address like ?"); preparedStatement.setString(1, data.toString()); preparedStatement.setString(2, resultset.getObject(column + 1).toString()); preparedStatement.executeUpdate(); } else if (column == 3) { preparedStatement = connection.prepareStatement("update rms_accountstore tin_number = ...

56. problem with java --> sql    java-forums.org

hey, i'm trying to learn some java and started my own project where i'm trying to filter from dates but i get the following error with this sql statement. what is wrong here ? SQL="SELECT * from info where firstdate between'" + Startdate.getText() +"'" + "and'" + Enddate.getText() +"'" + ",count(topic) FROM INFO GROUP BY topic'" ; Caused by: java.sql.SQLException: near ...

57. I dont get it! How do I create an sql database on my own computer?    java-forums.org

Hello! I'v been searching all morning trying to figure out how to do it. I tried downloading Microsoft SQL Server 2008 R2 But it can't find the server MSSQLSERVER as I belive I named it while using the setup. Anyways, Im woundering if there is any simple way to create an SQL database AND be able to use it?! Following an ...

58. Databse noob - Java SQL questions    java-forums.org

Hello, we have a database in our Java program which holds information about registered users, etc. and I am a complete database noob. Now in sql there is this ALTER TABLE ... ADD COLUMN syntax, which lets you add a column to an existing table. Now I want to know how I can skip this if the table already has the ...

59. Sql    java-forums.org

I'm not completely sure of this, but when you establish connection to the database you don't seem to give it a username or password. Try adding that to the end of your connection statement. :) If i remember correctly it should look like this: Connection con = DriverManager.getConnection("jdbcdbcracle-datasource", "system", "mahesh"); PS: I'm a beginner but this is what caught my eye ...

60. Sql    java-forums.org

61. java.beans or java.sql or    java-forums.org

I'm new to java n as I viewed the API list, I thought java.sql is the one to use, however when I tried one of netbeans build-in package I see that it's using java.beans instead, so now I wonder which one to use...more to what advantage n disadvantage of using the both or maybe using other than those two if there's ...

62. SQL problems    java-forums.org

Connected to database Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. at Userinfo.button1MouseClicked(Userinfo.java:40) at Userinfo.access$100(Userinfo.java:12) at Userinfo$2.mouseClicked(Userinfo.java:204) at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253) at java.awt.Component.processMouseEvent(Component.java:6041) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5803) at java.awt.Container.processEvent(Container.java:2058) at java.awt.Component.dispatchEventImpl(Component.java:4410) at java.awt.Container.dispatchEventImpl(Container.java:2116) at java.awt.Component.dispatchEvent(Component.java:4240) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3995) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916) at java.awt.Container.dispatchEventImpl(Container.java:2102) at java.awt.Window.dispatchEventImpl(Window.java:2429) at java.awt.Component.dispatchEvent(Component.java:4240) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) ...

63. SQL code    java-forums.org

My one Userinfo class sends information to the SQL class to put it into the database but it gives errors that I can't figure out. I have tried everything. If I test it with jut my SQL class with Strings that I type in it runs, but the information isn't in the database. AArgh so frustrating!!! Here is the Userinfo class ...

64. Java retrieving SQL dbo. scripts    forums.oracle.com

Hi all, I know this falls more under the SQL Database than java. I need to retrieve the Create Scripts of a database's objects. [georgemc|http://forums.sun.com/thread.jspa?messageID=10382707#10382707] suggested that I retrieve the scripts directly from the database instead of re-generating the scripts from meta-data. The method I used to re-generate the table scripts works (but long process), but I also need the scripts ...

65. Why Java is case sensitive unlike SQL?    forums.oracle.com

I simply said that as many classes in java use the underlying equals object method for their implementations, we can assume that those classes automatically become case sensitive by nature and if you want to be more general then we can say its the guideline which SUN has which the JVM developers have implemented.

66. Java + SQL    forums.oracle.com

I think the key word you should look into is JDBC. Its how java gets data from a database into the Java project. However, you need to install a database first and create the tables using the database utility tool. You can download Oracle Lite or MySql (both free) and read its documentation first. Ideally, you should read a book on ...

67. java.sql interfaces    forums.oracle.com

68. Using SQL in Java    forums.oracle.com

69. java.sql.SQLSyntaxErrorException    forums.oracle.com

You can't just stick text values willy nilly into a SQL query and have it work. You have to quote them. Better though for you to use a PreparedStatement which will handle this and a few other things for you. [See a Sexy Article on PreparedStatements with some simple usage examples by clicking here|http://sdnshare.sun.com/view.jsp?id=525|Click me baby!]

70. sql commands    forums.oracle.com

Pretty much any intermediate to advanced SQL book. The basic insert from a select or subquery type of stuff should be coverd in any decent SQL book. I use Oracle, so I got a lot of specifics for Oracle's SQL dialect from the Oracle publications and docs. MS-SQL server has similar stuff as does the rest of the production ready SQL ...

71. Java web service: XML to SQL    forums.oracle.com

Background: I am a second year degree student currently on placement. The company I am with wants me to design a web service that listens for incoming XML data from an external system and uses this data to update a database. Does anyone have any tips as to the best place to start?, what API's will be required? or just general ...

72. SQL Output    forums.oracle.com

73. is this sql querry correct?    forums.oracle.com

74. import java.sql.*    forums.oracle.com

75. object Construction... based on an SQL question???    forums.oracle.com

**SQL...** Maybe the question will be stupid, but this is my doubt, I know how to construct an object based on a table... but what happens when it is a combination of tables... or I contruct the object based on the results I will get from the run. or I have to contruct an object for each table I have to ...

76. SQL with OOP Technics    forums.oracle.com

77. SQL AVG problem    forums.oracle.com

Because the AVG function returns the result in the same datatype as the variables passed in. You are passing in a load of integers (full numbers) and as such the AVG function returns the nearest whole number i.e. 3 Again I say this JAVA forum is not the place for SQL questions. Try a SQL forum

79. How to access the sql database in applet?    forums.oracle.com

80. sql problem    forums.oracle.com

when i execut this query i get the result set values as follows 10 10 10 10 10 5 5 5 5 10 10 10 5 5 5 5 5 5 16 16 16 16 16 16 16 5 5 5 5 10 5 5 10 10 10 5 16 so is ter any wa so that my resultset contains only ...

81. SQL values    forums.oracle.com

This is my first attempt using a db (MYSQL) and I need help. I have a Primary key in the db as empid char(5) Primary Key, in my project I need to know what data type I needs to use. I will be using a scanner to prompt the user to input info for that field. thnaks SandyR PS I tried ...

82. how can i transfer SQL database to other m/c    forums.oracle.com

83. sql help-Please help-urgent help req-i have 2probs    forums.oracle.com

Second Problem is that in a servlet page "show profile", i want to access the personal details along with the dateof application so what method i thought was as (rs.getDate()) returns an java.sql.Date object, i can apply some methods of java.sql.Date on this object being returned to get the integer values of date month and year seperately.Then create string variable by ...

84. java.sql.*    forums.oracle.com

85. Sql help!!    forums.oracle.com

Hi all, I currently have a list of teams and there current points set up in an oracle database, which is in the form of a league table. I also have a file in which I have the results set up as hometeam, homescore, awayscore, awayteam. I am struggling and canty understand how I can update the database table e.g winner ...

86. Help on SQL    forums.oracle.com

hi guys, my problem is mathing a date with sql in my java application. for example: String cur_date = "18/12/2006" String strsql = "SELECT * FROM invoice_table WHERE inv_Date => cur_date; The above SQL statement gives a null value output even though there are records mathing to the above query. please help me out to sort this out

87. Help: Java SQL    forums.oracle.com

88. problem in sql    forums.oracle.com

hi all, iam having a table by name owner whos is having a particular filed by name mapclientid.one owner is assigned more than one client.iam having a mapping table and in that iam having two fields mapclientid and client id.another table iam having is clients in which iam having many information and also a field by name clientid.the clientid in the ...

89. runtime sql querries    forums.oracle.com

void getsql() { String sql="select"; int index=0; for(Column col:cols) { sql+=col.getName; if (index > 0) { sql+=","; } index++; } sql=sql+"from"+TableName; // } } }} i wanna create querry like above plz now tell me how can i use execute statement.act i wanna work in command line, plz check this code and help me plz plzzzzzzzzzzzzz

90. Use of ROWNUM of SQL    forums.oracle.com

Hey All, I am using Oracle DB and in that I am retrieving data from DB with WHILE() in Java, but I want to perform different operations on even and odd rows i.e. like changing colors etc. I guess ROWNUM of SQL might be helpful but I am not sure how, so can any1 please help regarding this? Thax & rgds, ...

91. have problem with sql    forums.oracle.com

Use a [http://java.sun.com/javase/6/docs/api/java/sql/PreparedStatement.html] instead. Then you do not have to worry about escaping strings between different databases (among other benefits). You should not expect anything sensible to be output from ResultSet#toString(). What you are seeing is simply the output when a given implementation does not provide a custom toString() method, which is true of most result sets. - Saish

92. Java and SQL Question    forums.oracle.com

I am a student and fairly inexperienced with java and sql but here's a question: I want to collect data from a remote sql database and dump it into a local excel file or something similar. I'm thinking of using a java program to do this. Do I need to use http requests? Roughly what would this program look like? Thanks, ...

93. SQL problem    forums.oracle.com

You are doing two things at the same time on stmt, and that is not allowed: you are iterating over the result set and trying to execute DELETEs at the same time. I would first put ALL the ids into the list, then do all the deletes. You should also come up with a single SQL statement rather than doing multiple ...

94. Java Databases, anyone with knowledge of SQL please help.    forums.oracle.com

If I were to make a JAVA program that was to hold information on members of a sports club, IE name, address, age, tournaments won etc... I would need to be able to add, modify, sort and delete data in a nice user interface. How would I go about doing it? Should I do the database in SQL? Is there a ...

95. Newb help. SQL Problem.    forums.oracle.com

96. IP Address + SQL    forums.oracle.com

First of all are you sure that int is the correct type for that field? I don't know what database this is and you didn't say but the postgres inet type seems to look awfully much like a specialized char field. 12 bytes to 24 bytes? An int (or long for IP 6) would be 4 or 8 bytes. Which by ...

97. what is difference between functions and procedures in sql    forums.oracle.com

PL/SQL has two types of subprograms, procedures and functions. Procedure: ? A procedure is a type of subprogram that performs an action. ? A procedure can be stored in the database, as a schema object, for repeated execution. Functions: ? A function is a named PL/SQL block that returns a value. ? A function can be stored in the database as ...

98. Programming architecture for a desktop application with sql    forums.oracle.com

Hi I'm have been developing a desktop application and wants to save the data to a SQL-server.The problem is i am quite unsure how i the architecture of my classes should be regarding to this. What would be the right procedure between theese two exemplaes (If theyre both wrong im happy to hear about it). Edit: After reading some other posts ...

99. SQL Reporting Services with Java EE    forums.oracle.com

I have already developed a java EE for calling reports with the help of ---"MSDN Virtual Lab: Implementing SQL Server Reporting Services with a Java Enterprise Edition (EE) Application (ID:1032315323)". Now I need to find out the parametrized reports(passing parameters to the report calls and more customization using java). In .NET, reportviewer controller is available for this purpose. I want to ...

100. Sql problem    forums.oracle.com